Which three are true about Optimizer Statistics Advisor? (Choose three.)
Posted: Sun Jun 11, 2023 3:55 pm
Which three are true about Optimizer Statistics Advisor? (Choose three.)
A. It can be run only manually.
B. It is part of the DBMS_ADVISOR package.
C. It can recommend changes to improve the statistics gathering process.
D. It always analyzes all schemas in the database. E. It runs automatically every night by default. F. It is part of the DBMS_STATS package.
A. It can be run only manually.
B. It is part of the DBMS_ADVISOR package.
C. It can recommend changes to improve the statistics gathering process.
D. It always analyzes all schemas in the database. E. It runs automatically every night by default. F. It is part of the DBMS_STATS package.