You want to analyze only the columns price and quantity in the sales table to speed up statistics collection. Which command achieves this?

hard📝 Application Q8 of 15

PostgreSQL - Performance Tuning

You want to analyze only the columns price and quantity in the sales table to speed up statistics collection. Which command achieves this?

AANALYZE sales ONLY price, quantity;

BANALYZE sales WHERE column IN ('price', 'quantity');

CANALYZE sales(price, quantity);

DANALYZE sales COLUMNS price, quantity;

Step-by-Step Solution

Solution:

Step 1: Recall syntax for analyzing specific columns
PostgreSQL allows ANALYZE tablename(column1, column2) to analyze specific columns.
Step 2: Check other options
Options A, B, C use invalid syntax or keywords not supported.
Final Answer:
ANALYZE sales(price, quantity); -> Option C
Quick Check:
ANALYZE with column list uses parentheses [OK]

Quick Trick: Use ANALYZE tablename(column1, column2) for specific columns [OK]

Common Mistakes:

Master "Performance Tuning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free