Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Forcing use of Index without Hint

599375May 31 2010 — edited May 31 2010
Hi

There are tables with more than 100 Million Records in our 11.1.0.7 database on Windows. SQL queries are not using Index resulting in huge Direct Path Read waits due to full table scan.

When i use index hint in sql the execution is pretty faster.

I cannot hard code the Index Hint in the end user application.

I would like to know if i can force Oracle to use index with out the hints ?

Regards,
Mudassir
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2010
Added on May 31 2010
#general-database-discussions
14 comments
2,556 views