RE: partitioning in a data warehouse environment
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <Sharon.Kovac@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 17 Nov 2009 11:23:24 -0500
Sharon,
Since Igor has given you a very logical and valid response to the
basics of your inquiry I won't spend time redoing that. One item I've
found with partitioning schemas is that they leave out the default or
catch all partition. Don't do that. If you have a default partition
then you can easily split that partition vs. the fun of a failing insert
statement and a hurried add partition statement to follow. Easier to
have a default partition and a maintenance action afterwards that can be
thought out and planned.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Sharon.Kovac@xxxxxxxxxxxxxxx
Sent: Monday, November 16, 2009 4:12 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: partitioning in a data warehouse environment
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.
---------------------------------------------------------------------
.
Other related posts:
