Which statement is true about the following mxic command?
mxci>> control query default optimization_level ‘0’;

A.
The compiler performs full optimization of the query using exhaustive search algorithms.

B.
This optimization level is best when accessing large tables resulting in complex query plans.

C.
The compiler uses heuristic information about data objects to perform one-pass optimization.

D.
This optimization level is often specified in decision support system (DSS) environments.