Database Performance & Scaling

After you know how to design tables and write SQL, the next question is:

How do we keep the database fast and reliable as data and traffic grow?

This area covers indexing, query plans, scaling strategies, and advanced internal concepts.

What comes under Performance & Scaling?

Database Performance & Scaling
├── Indexing
├── Query Optimization
├── Database Scaling
└── Advanced Concepts

Start with indexing, because most practical query performance discussions begin there.