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

Get Premium PostgreSQL-Essentials Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lai

Definitely B) ANALYZE emp; ANALYZE dept;

upvoted 0 times

...

Jin

5 days ago

B is correct, but I still prefer VACUUM for cleanup too.

upvoted 0 times

...

Cathrine

10 days ago

Surprised that people confuse VACUUM with ANALYZE.

upvoted 0 times

...

Esteban

15 days ago

No way, it's all about ANALYZE for stats!

upvoted 0 times

...

Felice

2 months ago

I thought VACUUM was the right choice?

upvoted 0 times

...

Lorrie

2 months ago

Definitely B) ANALYZE emp; ANALYZE dept;

upvoted 0 times

...

Jody

3 months 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

...

Marica

3 months 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

...

Janae

3 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

...

Freeman

3 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

...