Indexes are special lookup table can be created in a database table to speed up the performance of queries. It is of two types clustered and non-clustered index.