Binary SemaphoreBinary Semaphore/learn
mentorshiptopicsroadmapsnotebooks
sign in
CC++JavaPythonJavaScriptTypeScriptGoDSAOperating SystemsNetworksDatabasesSystem DesignTheory and CompilersMaths for CSFrontendBackend and APIsSecurityCloud and DevOpsTestingAIGit and the ShellDebuggingInterviews and Viva
Databases
  • normalisation-for-the-exam
  • indexes-and-slow-queries
  • transactions-and-isolation
  • the-n-plus-one
  • interview-questions
  • viva-defence

© 2026 Binary Semaphore

discord

Databases

Indexes, and why it crawls

What an index is, what it costs on write, and reading EXPLAIN without guessing.

There is work of ours behind this. It is linked on the right.

Want this written up?

Sign in and tell us. We write the ones people actually ask for, and asking takes one click.

Sign in to ask

Or sit with someone on it instead of waiting for us to write it.

What we have

NotebookPostgres
Book an hour on this