1.
|
What is true about the rule-based optimizer? (Choose all that apply)
Please select all the correct answers. |
|
A. |
The rule-based optimizer relies on statistics from the ANALYZE command.
|
|
B.
|
The rule-based optimizer chooses indexes based on their selectivity.
|
|
C.
|
The rule-based optimizer requires careful sequencing of items in the FROM and WHERE clauses.
|
|
D.
|
The rule-based optimizer is sometimes faster for complex multi-table equi-joins.
|