EXPLAIN ANALYSE <SQL-Query>
| Description | |
|---|---|
| Statistics | Statistics (from ANALYZE) about row counts and data distribution. |
| Cost Estimates | Cost estimates (CPU, I/O, memory) |
| Case Study | Remarks |
|---|---|
| Finding Orders for a Customer | Simple Case study with sequential scan vs indexes |
| Finding all customer orders | Optimization using indexes and pre-aggregation helps |