What is Indexing?
Creating a data structure that makes database lookups much faster, like an index in a book.
Why It Matters
Without indexes, the database must scan every row to find what you need, which gets very slow with large datasets.
Real-World Example
Adding an index on the email column lets the database find a user by email in milliseconds instead of seconds.
“Understanding terms like Indexing matters because it helps you have better conversations with developers and make smarter decisions about your software. You do not need to be technical. You just need to know enough to ask the right questions.”
Related Terms
Query Optimisation
The process of making database queries run faster and use fewer resources.
Database
An organised collection of data that your application can store, retrieve, and update
SQL
A language for communicating with databases, used to create, read, update, and delete data
Denormalisation
Deliberately adding redundant data to a database to improve read performance.
Learn More at buildDay Melbourne
Want to understand these concepts hands-on? Join our one-day workshop and build a real web application from scratch.
Related Terms
Database
An organised collection of data that your application can store, retrieve, and update
SQL
A language for communicating with databases, used to create, read, update, and delete data
Denormalisation
Deliberately adding redundant data to a database to improve read performance.
Query Optimisation
The process of making database queries run faster and use fewer resources.
NoSQL
Databases that store data differently from traditional tables, often as flexible documents or key-value pairs
PostgreSQL
A powerful, free, open-source database known for reliability and advanced features