RE: Partitioned Indexes question

From: Lim, Binley <Binley.Lim_at_NBNZ.CO.NZ>
Date: Thu, 18 Mar 2004 18:21:28 +1300
Message-ID: <5FA85DB5FB07D7118CF50002A5754C0902E2CA33@nbnzhexch2.nbnz.co.nz>

I was referring to the case where you explicitly use the keyword LOCAL because you want the index to be partitioned on the same column(s) as the table.

I cannot think of a case where anyone would include the keyword GLOBAL, and then expect Oracle to convert it into LOCAL.

> -----Original Message-----
> From: Tanel Poder [SMTP:tanel.poder.003_at_mail.ee]
> Sent: Thursday, March 18, 2004 10:46 AM
> To: oracle-l_at_freelists.org
> Subject: RE: Partitioned Indexes question
>
> On Tue, 2004-03-09 at 08:11, Lim, Binley wrote:
> > If an index is partitioned on the same column(s)
> > as the table, then the index is local. If you partition
> > on different columns, then the index is global, and you
> > have to specify the range in the index-create statement.
>
> That's not true, at least in this wording. You can have a GLOBAL index
> partitioned exactly on same columns as the table, also equi-partitioned
> with the same value ranges as the table. If you state an index is GLOBAL,
> it will be GLOBAL, Oracle won't convert it to LOCAL by itself.
>
>

This communication is confidential and may contain privileged material. If you are not the intended recipient you must not use, disclose, copy or retain it. If you have received it in error please immediately notify me by return email and delete the emails.
Thank you.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Mar 17 2004 - 23:20:21 CST