Hi,

I know from Oracle 8i that you can make use of Function indexes,

But is there a way to get a query that makes use of a function in the where clause to use an index in Oracle 8.0.5 instead of doing a full table scan.

Thanks,