Can I read Understanding Oracle Optimizer Hints on EtoBox?
Understanding Oracle Optimizer Hints by jazboy is a document available to read on EtoBox.
What is Understanding Oracle Optimizer Hints about?
Optimizer hints can be used to instruct the optimizer to choose a specific execution plan. Hints provide a way for application designers to specify plans based on data insights not available to the optimizer. There are several types of hints including single-table, multi-table, query block, and statement hints. Hints cause the CBO to be used and it is good practice to analyze tables when using hints.
- Author
- jazboy
- Language
- EN