Discussion :: DBMS MCQs
- 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 : Option D
Explanation :
All of the mentioned
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.
Be The First To Comment