DEVFYI - Developer Resource - FYI

How can one optimize %XYZ% queries? (for DBA

ORACLE Interview Questions and Answers (Part 3)

(Continued from previous question...)

382. How can one optimize %XYZ% queries? (for DBA

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 table (which is usually the case) it will take less time to scan the entire index than to scan the entire table.

(Continued on next question...)

Other Interview Questions