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.
Sunday, December 9, 2012
PostgreSQL - ANALYZE quiz
at 6:15 AM
Labels: PostgreSQL, PostgreSQL Query, PostgreSQL Quiz, PostgreSQL Tip
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment