MS SQL Server Indexes Question:
Download Job Interview Questions and Answers PDF
determine when an index is appropriate?
Answer:
a. When there is large amount of data. For faster search mechanism indexes are appropriate.
b. To improve performance they must be created on fields used in table joins.
c. They should be used when the queries are expected to retrieve small data sets
d. When the columns are expected to a nature of different values and not repeated
e. They may improve search performance but may slow updates.
b. To improve performance they must be created on fields used in table joins.
c. They should be used when the queries are expected to retrieve small data sets
d. When the columns are expected to a nature of different values and not repeated
e. They may improve search performance but may slow updates.
Download SQL Server Indexes Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain the purpose of indexes? | Write down the syntax and an example for create, rename and delete index? |