Oct 3, 2018

Index All Columns Used in 'where', 'order by', and 'group by' Clauses

Apart from guaranteeing uniquely identifiable records, an index allows database server to fetch results faster from a database.

An index is also very useful when it comes to sorting records.