Implementing Query Hints
Placing hints in SQL is a common and simple approach to improve performance. Hints influence Oracle’s optimizer to take a specific path to accomplish a given task, overriding the default path the optimizer may have chosen. Hints can also be viewed as a double-edged sword. If not implemented and maintained properly, they can hurt performance in the long run.
KeywordsQuery Result Nest Loop Execution Plan Select Statement Access Path
Unable to display preview. Download preview PDF.