---
title: "What is an Index?"  
description: "What is an Index?"  
author: "Rahul Roi"  
published: 2019-05-06  
updated: 2020-09-21  
canonical: https://www.mindstick.com/interview/23506/what-is-an-index  
category: "database"  
tags: ["database", "sql server"]  
reading_time: 1 minute  

---

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

## Answers

### Answer by Rahul Roi

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.


---

Original Source: https://www.mindstick.com/interview/23506/what-is-an-index

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.