On Tue, Oct 4, 2011 at 12:45 AM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx> wrote: > You might want to provide us the execution plan and the DDL of the index, if > you want us to take a closer look. > DB version , server spec and memory configuration will be helpful as well to do any recommendations. regards, -- Marcin Przepiorowski http://oracleprof.blogspot.com -- //www.freelists.org/webpage/oracle-l