MS SQL Server Indexes Question:

Download Job Interview Questions and Answers PDF

Can you explain important index characteristics?

SQL Server Indexes Interview Question
SQL Server Indexes Interview Question

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

Download SQL Server Indexes Interview Questions And Answers PDF

Previous QuestionNext Question
Explain Having clause and Where clause?Explain the types of indexes?