From the objective of OSS-DB Exam Gold
- Advanced Server Administration - Commands for database administration
Sample Question
1.09
Select all the statements that are correct regarding ANALYZE.
-
If sorted data is loaded in ascending order, the optimal query plan is created without running ANALYZE.
-
The autovacuum daemon may perform ANALYZE operations.
-
Increasing the value of default_statistics_target will reduce the time required for ANALYZE, but may degrade the quality of the planner's estimates.
-
A SHARE UPDATE EXCLUSIVE lock is acquired on the target table.
-
The PostgreSQL ANALYZE statement is compliant with the SQL standard.
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2025/05/29
Answer and Explanation
A. There is no direct relationship between the order in which data is loaded and the quality of the execution plans generated.
B. The autovacuum daemon may perform ANALYZE in addition to VACUUM.
C. Increasing the value of default_statistics_target will increase the time required for ANALYZE and improve the quality of the planner's estimates.
D. ANALYZE obtains a SHARE UPDATE EXCLUSIVE lock, which does not interfere with SELECT, INSERT, or other similar statements.
E. The ANALYZE statement is not part of the SQL standard.
Therefore, the correct answers are B and D.