Re: Column order in indices (oracle 9.2)

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 1 Aug 2006 07:57:21 -0700
Message-ID: <1154444241.44cf6bd16221d@webmail.hosting.telus.net>

Is the partitioning based on the first(leading) column of the index? In my experience - don't know if it's a fixed rule - a local partitioned index is not being used unless the partitioning column is among the predicates. Having said that, I haven't had a chance to possibly revise that experience with Oracle 9.2 or 10.

Quoting genegurevich_at_discoverfinancial.com:

> Yechiel:
>
> The answers are yes and yes - the index is partitioned locally and I do
> have the histograms
>
> thank you

-- 
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 01 2006 - 09:57:21 CDT