SQL & PL/SQL

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!

use Hint to force using index does not work!

628781Apr 17 2008 — edited May 14 2008

I want to use hint to force using a index . I run the sql in "PLSQL Developer", but when I use explain function. It seems that the db uses another index instead of the index which I specified.

Are there any possibility for this case? The oracle is 9.2

The SQL is something like:
SELECT
/*+INDEX (TABLEX INDEX_A) */
*
FROM
TABLEX

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 11 2008

Added on Apr 17 2008

25 comments

45,066 views