What is Index?

Index- a term used in various fields, refers to a list of items arranged systematically. In computer science, an index is a data structure that improves the speed of accessing data from a database table.

Indexes are used to optimize search queries by reducing the number of database pages that need to be visited. They can also enforce uniqueness constraints on tables and improve the performance of joins between two or more tables.

In simpler terms, an index is like a roadmap for your database. It helps you find what you're looking for without having to search through everything manually.