Query Is Not Using Index

[shailendra]

Hi Friends,

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
Shailendra

[SANJAY_G]

Shailendra,
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?

[shailendra]

thanks for reply Sanjay

I got the solution there was some problem in the query I rectify that now it is working fine

Thanks again
Shailendra

[chrisrlong]

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.

Thanks,

- Chris