InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Can One Optimize %xyz% Queries? |
|
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 table (which is USUALLY the case) it will take less time to scan the entire index than to scan the entire table. 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. |
|