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.
|