Re: Queries vs Indexes and the 10053

From: Don Seiler <>
Date: Fri, 1 Feb 2008 13:53:45 -0600
Message-ID: <>

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


On Feb 1, 2008 11:29 AM, Don Seiler <> 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
Received on Fri Feb 01 2008 - 13:53:45 CST

Original text of this message