subject:"RE\: Deciding what columns to partition on"

Re: Deciding what columns to partition on

2001-12-18 Thread Stephane Faroult

[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

Re: Deciding what columns to partition on

2001-12-18 Thread Jared Still

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

RE: Deciding what columns to partition on

2001-12-18 Thread Khedr, Waleed

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

Re: Deciding what columns to partition on

2001-12-19 Thread Stephane Faroult

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