Skip to content

Opening book details…

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