What is Index? and its importance?

  • 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.

Share :

Twitter

Random Posts

Back To Top

facebook main

counter

Powered by Blogger.