Full table scan used instead of index?

Hi, I have a table with approx. 419241 records. I'm using Oracle 8.1.6.0 on Windows 2000.

A query like:

select * from test where c='0123456789012345'

takes extremely long time (18 sec), and in the execution plan it says that a full table scan is used. The strange thing is that it does not use the index which is defined for the column - even if a hint is used!

The table is creates as:
CREATE TABLE(c raw(32),t raw(32));

Can indexes work on the raw(32) data type?

Best regards
Thomas Received on Tue Aug 14 2001 - 22:28:28 CEST