Podcast
Questions and Answers
What type of index contains the physical locations of the rows in the table?
What type of index contains the physical locations of the rows in the table?
In what form does the base data exist if a non-clustered index is separate from it?
In what form does the base data exist if a non-clustered index is separate from it?
What does a filtered index contain?
What does a filtered index contain?
Which type of index can contain copies of non-key column values at the leaf level of the index tree?
Which type of index can contain copies of non-key column values at the leaf level of the index tree?
Signup and view all the answers
What happens if values from columns not in the non-clustered index are requested?
What happens if values from columns not in the non-clustered index are requested?
Signup and view all the answers
Can a clustered index be filtered?
Can a clustered index be filtered?
Signup and view all the answers
What is the purpose of a clustered index?
What is the purpose of a clustered index?
Signup and view all the answers
Why might a non-clustered index take longer for a query on Employee2 compared to Employee1?
Why might a non-clustered index take longer for a query on Employee2 compared to Employee1?
Signup and view all the answers
What is the drawback of using indexes?
What is the drawback of using indexes?
Signup and view all the answers
What is the advantage of using a clustered index?
What is the advantage of using a clustered index?
Signup and view all the answers
Why might indexes slow down updates, deletes, and inserts?
Why might indexes slow down updates, deletes, and inserts?
Signup and view all the answers
What is the purpose of INCLUDE columns in an index?
What is the purpose of INCLUDE columns in an index?
Signup and view all the answers
