MS SQL Server Indexes Question:
Download Job Interview Questions and Answers PDF
Can you explain important index characteristics?
Answer:
The characteristics of the indexes are:
They fasten the searching of a row.
They are sorted by the Key values.
They are small and contain only a small number of columns of the table.
They refer for the appropriate block of the table with a key value
They fasten the searching of a row.
They are sorted by the Key values.
They are small and contain only a small number of columns of the table.
They refer for the appropriate block of the table with a key value
Download SQL Server Indexes Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain Having clause and Where clause? | Explain the types of indexes? |