wildcard search and full tablescans

Oracle10g 10.2.0.1

select * from <table_name> where <column_name> like '%abc%';

does not use the index and does a full tablescan (guess this is the expected behaviour as per explain plan).

Any suggestions as to how to use the index (index hint didn't help), IF possible or other alternatives.

thanks Received on Thu Dec 07 2006 - 05:55:32 CST