MS SQL Server Indexes Question:

Download Job Interview Questions and Answers PDF

Explain the purpose of indexes?

SQL Server Indexes Interview Question
SQL Server Indexes Interview Question

Answer:

Allow the server to retrieve requested data, in as few I/O operations
Improve performance
To find records quickly in the database

Download SQL Server Indexes Interview Questions And Answers PDF

Previous QuestionNext Question
What is Unique Index?determine when an index is appropriate?