What is Database INDEX?

Indexes are special lookup tables that the database search engine can use to speed up data retrieval. simply put, an index is a pointer to data in a table. an index in a database is very similar to an index in the back of a book.

without an index,rows are search sequentially.

Index can jump directly to the row that matches the search pattern.

Index helps to a database run faster.

When you create a table especially hold many rows of data, create it with an index.

Indexes are based on tree data structures or hash data structures.