Jared Still wrote:
On Tuesday 18 December 2001 12:55, Stephane Faroult wrote:
I have never found the argument 'you
scan a single partition' very compelling when your data is properly
indexed.
Stephane,
This is assuming that you are using global indexes on your
partitioned tables.
recipients of list ORACLE-L
[EMAIL PROTECTED]
sfaroult@orio cc:
le.com Subject: Re: Deciding what columns to
partition on
Sent
: RE: Deciding what columns to
partition on
Sent by:
[EMAIL PROTECTED
:
le.com Subject: Re: Deciding what columns to
partition on
Sent by:
[EMAIL PROTECTED
We are doing a redesign of our 200-Gig data warehouse in 9i.
One of the things we're thinking about is changing which
columns we partition on.
Currently, we partition exclusively on date fields. This has
proven extremely helpful for doing maintenance, purging
old data, archiving, etc.
[EMAIL PROTECTED] wrote:
We are doing a redesign of our 200-Gig data warehouse in 9i.
One of the things we're thinking about is changing which
columns we partition on.
Cherie,
I am not sure that this really relates to your problem but if I think
that you should consider partitioning
On Tuesday 18 December 2001 12:55, Stephane Faroult wrote:
I have never found the argument 'you
scan a single partition' very compelling when your data is properly
indexed.
Stephane,
This is assuming that you are using global indexes on your
partitioned tables. If using local indexes and
Did you consider partitioned IOT?
Have fun,
Waleed
-Original Message-
Sent: Tuesday, December 18, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L
We are doing a redesign of our 200-Gig data warehouse in 9i.
One of the things we're thinking about is changing which
columns we