MS SQL Server Indexes Question:
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
| Previous Question | Next Question |
| Explain Having clause and Where clause? | Explain the types of indexes? |