|
I’ve been reading the 9iR2 docs on partitioning, along with Tom Kyte’s
excellent chapter on the subject. It
seems that a Global index or unique, local indexes could be used effectively in
an OLTP system, but both have their caveats. This is a hybrid system- it’s part OLTP but is also used quite a bit for
reporting. Would anyone out there care
to share your good or bad experiences with these indexes on partitioned tables
in such a system? Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency
Parkway, Suite 100 Cary, NC
27511-8582 Office (919)
466-6723 Mobile (919)
412-8462 Pager
[EMAIL PROTECTED] Fax (919)
466-6783 AIM adswDWagoner http://www.arsenaldigital.com/
*** NOTICE *** This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, work product or exempt from disclosure
under applicable law. If you have
received this message in error, or are not the named recipient(s), please immediately
notify the sender by phone or email and delete this e-mail message from your
computer. Thank you. |
