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 ? 

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
----- Original Message ----- From: "Orysia Husak" <Orysia.Husak@xxxxxxxxxxxxx> 
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

index.




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

Other related posts: