Query optimisation using database indexes
A common question in software engineering interviews is _how can you speed up a slow query?_ In this post I want to explain one answer to this question, which is: to add an index to the table the query is performed on.
Tags: sql, database, engineering