Indexes enable database applications to find data faster without having to read the entire table.
Indexing You can create indexes in tables to query data more quickly and efficiently.
Users can't see the index, which can only be used to speed up search/query.
Note: Updating an indexed table takes more time than updating a table without an index, because the index itself needs to be updated. Therefore, it is best to create indexes only on columns (and tables) that are frequently searched.
Example:
Create a simple index on the table. Allow duplicate values:
From sloth school-free data knowledge learning platform