Question
Which option best describes the use of cost-based optimization in a database system?
Select an option. Your answer will be checked instantly.
Correct Answer: D. query plans are compared using estimated costs such as I/O, CPU, and cardinality
Explanation:
cost-based optimization is used in Advanced DBMS because query plans are compared using estimated costs such as I/O, CPU, and cardinality.
Leave a Reply