Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?
A. optimizer_prune_level
B. optimizer_search_depth
C. optimizer_search
D. optimizer_prune
Answer:A
Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?
A. optimizer_prune_level B. optimizer_search_depth C. optimizer_search D. optimizer_prune