RE: Index clustering factor

From: Orysia Husak <>
Date: Wed, 23 Jan 2008 13:37:47 -0700
Message-ID: <>


Thank you for your suggestions! There was indeed column conversion occurring causing the index not to be used.

I appreciate your assistance and love your book. Looking forward to the next one!


Orysia Husak
Sr. Oracle DBA - Classroom Applications Hosting University of Phoenix/ Apollo Group, Inc. Office: 602-557-6934
Mobile: 602-377-8586
-----Original Message-----
[] On Behalf Of Jonathan Lewis Sent: Thursday, January 10, 2008 12:10 AM To:
Subject: Re: Index clustering factor

The optimizer cannot ignore the index hint for that query. Therefore the hint is illegal.

The first thing to check is whether you have a column coercion issue. What are the types of the columns and of the input variables - and what does OEM tell you about the run-time predicates ?


Jonathan Lewis

Author: Cost Based Oracle: Fundamentals

The Co-operative Oracle Users' FAQ

  • Original Message ----- From: "Orysia Husak" <> Subject: RE: Index clustering factor

The statement is expected to fetch only 1 or 2 rows. The default Oracle gather_stats generates a histogram size auto.

We've provided an index hint in the SQL and Oracle sill ignores the index.
>Our query is :
>Select * from tableA where fielda=:A and fieldb=:B
>We have an index on tableA (fielda, fieldb), but Oracle isn't using the


Received on Wed Jan 23 2008 - 14:37:47 CST

Original text of this message