Description : How can one optimize %XYZ% queries? (for DBA
Last Answer : It is possible to improve %XYZ% queries by forcing the optimizer to scan all the entries from the index instead of the table. This can be done by specifying hints. If the index is physically smaller than ... the case) it will take less time to scan the entire index than to scan the entire table.