What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

Showing Answers 1 - 4 of 4 Answers

Tirumal Devulapalli

  • Feb 23rd, 2006
 

CBO (Cost Based Optimizer):Generates an execution plan for a SQL statement

optimizer_index_cost_adj parameter can be set to help CBO to decide an execution plan, which effects the speed of SQL query.

we can also make necessary changes to the following parameters to effect CBO performance:

optimizer_search_limit & optimizer_max_permutations

  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