What is the purpose of index in sql server
A. To enhance the query performance
B. To provide an index to a record
C. To perform fast searches
D. All of the mentioned
Answer:A
What is the purpose of index in sql server
A. To enhance the query performance B. To provide an index to a record C. To perform fast searches D. All of the mentioned
Explanation: A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes.