Query Is Not Using Index
I have created on Index on a table when I execute one query where the Indexed column is in where clause but it is not using Index I tried through Hints also but still it is not using Index any idea why it is not using Index?
Thanks in Advance
Is it a composite index? Is the leading column of the index in where clause?
Can you post your query (with hint) and indexed columns? Also Oracle version?
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
thanks for reply Sanjay
I got the solution there was some problem in the query I rectify that now it is working fine
Thanks for the closure.
However, in the future, might I suggest a little more detail in the question?
"My car doesn't work and I don't know why" isn't much to go on, is it?
If you have a problem with a query... provide the query, and the plan.
If you have a problem with an index... provide the index.
Please take a moment and read the 'sticky' post at the top of this forum.
Click Here to Expand Forum to Full Width