MENU
You want to update statistics for the emp and dept tables to help the query planner. Which command should you use?
Suggested Answer: B
Get Premium PostgreSQL-Essentials Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
20 comments · newest first
NA
Nancey
1 month ago
B is definitely the best option here.
KE
Kent
1 month ago
C seems wrong. UPDATE STATISTICS isn't a real command.
KR
Krissy
2 months ago
VACUUM is for cleaning, not updating stats.
LE
Leeann
2 months ago
I feel confused about VACUUM and ANALYZE.
MA
Maricela
2 months ago
Agreed! It updates the statistics.
KA
Kayleigh
2 months ago
I think it's B. ANALYZE is the right choice.
ET
Ettie
2 months ago
C) UPDATE STATISTICS? That's not even a real command!
TE
Tegan
2 months ago
Wait, are we sure about B? Seems too simple.
KA
Kanisha
3 months ago
B is the right choice, helps the planner a lot.
MA
Maile
3 months ago
I thought it was A) VACUUM, but I guess not!
LA
Lai
3 months ago
Definitely B) ANALYZE emp; ANALYZE dept;
JI
Jin
3 months ago
B is correct, but I still prefer VACUUM for cleanup too.
CA
Cathrine
3 months ago
Surprised that people confuse VACUUM with ANALYZE.
ES
Esteban
4 months ago
No way, it's all about ANALYZE for stats!
FE
Felice
5 months ago
I thought VACUUM was the right choice?
LO
Lorrie
5 months ago
Definitely B) ANALYZE emp; ANALYZE dept;
JO
Jody
6 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.
MA
Marica
6 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.
JA
Janae
6 months ago
I'm not entirely sure, but I remember something about VACUUM and ANALYZE being related. Maybe it's not A?
FR
Freeman
6 months ago
I think it's B) ANALYZE emp; ANALYZE dept; because we learned that ANALYZE updates statistics for the query planner.