INDEX is generally used to make query access faster.It also takes less time for execution b'use it will not go for searching all the data's in the table.It will search only by using that INDEX.INSEX is created on the column of a table.Then a condition has also given in WHERE clause which will make it also more faster.