PostgreSQL Exam PGCES-02 Topic 5 Question 8 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 8
Topic #: 5

Select two correct statements from below concerning the ANALYZE command.

AIt renews the statistical information of the table content.

BIt takes some time to execute, but it does not lock the table.

CIf the FULL option is used when executing, the size of the file can be reduced.

DIf ANALYZE is insufficient, the most efficient search plan will not be selected for queries.

EIf ANALYZE is not used at all, there are times when it becomes impossible to see any of the data.

Show Suggested Answer

Suggested Answer: A, D

by Heike at May 07, 2022, 01:41 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!