EnterpriseDB PostgreSQL-Essentials Exam - Topic 4 Question 12 Discussion

Actual exam question for EnterpriseDB's PostgreSQL-Essentials exam

Question #: 12
Topic #: 4

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

18 days ago

I thought VACUUM was the right choice?

upvoted 0 times

...

23 days ago

Definitely B) ANALYZE emp; ANALYZE dept;

upvoted 0 times

...

1 month ago

REINDEX sounds familiar, but I don't think it updates statistics. I might be leaning towards B as well, but I need to double-check.

upvoted 0 times

...

1 month ago

I feel like I've seen a question like this before, and it was definitely about updating statistics, so I think B is the right choice.

upvoted 0 times

...

2 months ago

I'm not entirely sure, but I remember something about VACUUM and ANALYZE being related. Maybe it's not A?

upvoted 0 times

...

2 months ago

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

upvoted 0 times

...