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?

Interview Candidate
Dec 26th, 2005
2
3356

Showing Answers 1 - 2 of 2 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