DatabasesBackend
Database Indexing
Also written as Index
A technique for speeding up how a database finds data, similar to an index in the back of a book, at the cost of extra storage and slower writes.
Think of it like
Like the index in the back of a textbook — flipping to a page number instead of reading every page, at the cost of the extra pages the index itself takes up.
Junior or senior?
Junior sounds like
Adds an index whenever a query feels slow, without checking why.
Senior sounds like
Can walk through a slow query they diagnosed and describe whether indexing actually fixed it.
Ask them
“Tell me about a slow query you diagnosed and fixed. Was indexing involved?”