partitioning in a data warehouse environment
From: <Sharon.Kovac_at_Rotometrics.com>
Date: Mon, 16 Nov 2009 15:12:09 -0600
Message-ID: <OF932864A1.C08B6B5C-ON86257670.00730555-86257670.00747794_at_Rotometrics.com>
Date: Mon, 16 Nov 2009 15:12:09 -0600
Message-ID: <OF932864A1.C08B6B5C-ON86257670.00730555-86257670.00747794_at_Rotometrics.com>
We have a data warehouse running on version 11.1.0.7. Our fact tables contain anywhere from 4 million to 41 million records. We now want to partition some of the bigger, most frequently hit tables for both performance and maintenance. I'm new to partitioning so I'm spending time analyzing the queries that are run against the tables and I have a good idea on how to partition each table. My question is regarding indexes. I know that there are both local and global but I'm unsure when to use each. It's my understanding that a local index only contains information for the records in one partition and a global has information about the records in the entire table, correct? Are there some guidelines as to when to use each type? Thanks, Sharon --------------------------------------------------------------------- This e-mail message is intended only for the personal use of the recipient(s) named above. This message is confidential. If you are not an intended recipient, you may not review, copy or distribute this message. If you have received this communication in error, please notify the sender immediately by e-mail and delete the original message. --------------------------------------------------------------------- .
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 16 2009 - 15:12:09 CST