Re: Full table scan query

Although there are some bugs in the optimizer in 8.0.5, it should still obey a hint unless there is a good reason why the hint should be ignored.

Although I doubt you will have made such a trivial error, is it possible that your index hint was incorrect - e.g. using the table-name instead of the alias in the hint ?

The event that Sybrand was suggesting came out with a typo, I think, it should have been 10053.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Norman Dunbar wrote in message ...


>A developer is running the statement :

>

> select * from the_table where first_index_column = 'some_value';

>

>This will return 9 rows from the table.

>

>

>The explain plan gives a full table scan for the select above.

>When hinted to use the index, it refuses and again gives a FTS.