What is an index?
Indexes are tools to retrieve records by acceleration. An index column gets an entry for each value by an index production. Indexes are a companion with the various column, assist quick exploration and sufficient record management. Creating an index is consider which columns are frequently using in your query.
BY Best Interview Question ON 13 Jan 2019