Table Partitioning in a Hybrid-OLTP System

From: David Wagoner <dwagoner_at_arsenaldigital.com>
Date: Mon, 27 Jan 2003 13:33:41 -0800
Message-ID: <F001.0053B902.20030127133341@fatcity.com>

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 8666864767_at_archwireless.net
Fax (919) 466-6783
AIM adswDWagoner
 <http://www.arsenaldigital.com/> 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.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: David Wagoner
  INET: dwagoner_at_arsenaldigital.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jan 27 2003 - 15:33:41 CST