- Index is an object of table that is used to keep the data in organized form and helps faster retrieval of data.
In database systems, an index (IDX) is a data structure defined on
columns in a database table to significantly speed up data retrieval
operations. An index is a small copy of a database table sorted by key
values. Without an index, query languages like SQL may have to scan the
entire table from top to bottom to choose relevant rows.
