What is an Index?

Total Post:15

Points:75
 33  View(s)
Ratings:
Rate this:
  1. Post:15

    Points:75
    What is an Index?

    The index is performance tuning method of allowing faster retrieval of records from the table. The single index creates an entry for each value and it will be faster to retrieve data.

    An indexing is a way to optimize performance of a database by minimizing the number of disk accesses required when a query is processed.

    The index or database index is a data structure which is used to quickly locate and access the data in a database table.

Answer