SQL and databases: SQL Server

Sefism.

Chapter 07

Indexes and query plans

How indexes make reads fast, how to read what the database actually did with EXPLAIN or an execution plan, and the habits that keep queries quick.

10 concepts locked

Keep reading

7 more chapters, 61 more concepts, free with an account.

You have read the open chapters of the SQL and databases sheet. Every concept it covers is listed above, and an account opens the rest of them, the examples, the pitfalls and the whole library alongside it. Early access is open: sign up and your account is active shortly after.

Everything here is free to learn from. A few things, like adding a roadmap, keeping a cheat sheet or asking Tauseef a question, use credits. You get 15 when you join, your first roadmap is free, and if you are learning seriously and run out, you can ask for more. Credits only make sure the platform goes to people who are actually learning.

07 · Indexes and query plans7 / 10