Re: Index clustering factor
Date: Thu, 10 Jan 2008 07:10:07 -0000
Message-ID: <016801c85357$d51b3790$0200a8c0@Primary>
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_at_apollogrp.edu> 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-lReceived on Thu Jan 10 2008 - 01:10:07 CST