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. Howeve
[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 partiti
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 an
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 pa
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
> partiti
o: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject: Re: Deciding what columns to
partition on
Sent by:
"Khedr,
Waleed" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject: RE: Deciding what columns to
partition on
herie
Stephane
Faroult To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject: Re: Deciding what columns to
p