Re: TABLE ACCESS FULL

> Is there anyway I can force to do INDEX RANGE SCAN?

1- Use an index hint. Build an index on the columns in youtr WHERE clause and add a hint to the query.

2 - Set optimizer_index_cost_adj=10

3 - Add a rule hint. Rule will always use an index. Received on Wed Oct 22 2003 - 21:14:15 CDT