Sunday, December 9, 2012

PostgreSQL - ANALYZE quiz

What does the following command do?
Choose the correct answer below.
Note: "psql=#" is the command prompt for psql.
psql=# ANALYZE xyz;

A. Collects statistical information related to the content of the database xyz.
B. Collects statistical information related to the content of the table xyz.
C. Outputs statistical information related to the content of the table xyz.
D. No ANALYZE command in PostgreSQL, error will occur.
E. None of the above
F. Both B & C

Answer: [B]
Highlight to find out the answer.

No comments:

Post a Comment

Oracle Query