Re: Queries vs Indexes and the 10053

Just an addendum that the desired index is LOCAL. The table (and index) has 7 partitions, each with 18 subpartitions.

Don.

On Feb 1, 2008 11:29 AM, Don Seiler <don_at_seiler.us> wrote:
> Table FOO is partitioned by col4 monthly, and then subpartitioned by
> hash on another varchar2 field not used in this query. I also have an
> index on all fields in the predicate, but the order is (col1, col3,
> col2, col4). col1, col2, and col3 are varchar2, col4 is a date
> (obviously).

-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l