From the course: Advanced SQL for Query Tuning and Performance Optimization

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Solution: Analyze schema statistics

Solution: Analyze schema statistics - SQL Tutorial

From the course: Advanced SQL for Query Tuning and Performance Optimization

Start my 1-month free trial Buy for my team

Solution: Analyze schema statistics

“

(upbeat music) - [Narrator] We would use the ANALYZE command and specify the name of the table that we want to analyze and update the statistics on. In this case, it would be ANALYZE sensor_metrics;.

Contents