That's why the explain plant of the query forcing the index usage is important, "ideally" the cost should be bigger than using the full scan.... -- //www.freelists.org/webpage/oracle-l