What are optimizer hints?

Questions by rudhra97   answers by rudhra97

Showing Answers 1 - 7 of 7 Answers

Optimizer hints are used to alter execution plan of SQL statement. For ex, certain index can be sometimes more selective for certain queries. Based on the information you can choose a more efficient execution plan by using hint and telling the optimizer to choose a more optimal path.
Hints used for Optimization are :
All_rows
First_rows

     The optimizer hints determines the most efficient way to execute a SQL statement after considering many factors related to the objects referenced and the conditions specified in the query.
     The output from the optimizer is a plan that describes an optimum method of execution. The Oracle server provides the cost-based (CBO) and rule-based (RBO) optimization.

  Was this answer useful?  Yes

Art11

  • Sep 27th, 2011
 

A hint is an instruction to the optimizer. You can use optimizer hints with SQL statements to alter execution plans.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions