EnterpriseDB PostgreSQL-Essentials Exam - Topic 4 Question 12 Discussion

Actual exam question for EnterpriseDB's PostgreSQL-Essentials exam

Question #: 12
Topic #: 4

[All PostgreSQL-Essentials Questions]

You want to update statistics for the emp and dept tables to help the query planner. Which command should you use?

AVACUUM emp, dept;

BANALYZE emp; ANALYZE dept;

CUPDATE STATISTICS emp, dept;

DREINDEX emp, dept;

Show Suggested Answer

Suggested Answer: B

by Vilma at Apr 12, 2026, 04:32 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

3 days ago

I think it's B) ANALYZE emp; ANALYZE dept; because we learned that ANALYZE updates statistics for the query planner.

upvoted 0 times

...