Glossary: System Design Basics in JavaScript

Index

Also written: indexes, CREATE INDEX

A sorted lookup structure on a column that lets the database jump straight to matching rows instead of scanning the table. It slightly slows writes because each insert updates it.