PostgreSQL_CE
PGCES-02 · Question #33
What does the following command do? Select the correct description from below. Note: "text=#" is the command prompt for psql. test=# ANALYZE foo;
The correct answer is B. Collects statistical information related to the content of the tablefoo. See the full explanation below for the reasoning.
Question
What does the following command do? Select the correct description from below. Note: "text=#" is the command prompt for psql. test=# ANALYZE foo;
Options
- ACollects statistical information related to the content of the databasefoo.
- BCollects statistical information related to the content of the tablefoo.
- CCollects statistical information related to the content of the database test.
- DOutputs statistical information related to the content of the tablefoo.
- EThe command does not generate an error; however, it does not do anything either.
How the community answered
(27 responses)- B70% (19)
- C7% (2)
- D19% (5)
- E4% (1)
Community Discussion
No community discussion yet for this question.