interview

home / developersection / interviews / what is an index?

Ask Question
Rahul Roi

Student

I'm a professional writer and software developer with more than 10 years of experience. I have worked for a lot of businesses and can share sample works with you upon request. Chat me up and let's get started.....

Follow
Can you answer this question?
Answer

1 Answers

Rahul Roi

Rahul Roi

06-May-2019

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.

MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy