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?
- Filtered index
- Clustered index
- Non-clustered index (correct)
- Include index
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?
- B-tree
- Hash table
- Sorted array
- Heap (correct)
What does a filtered index contain?
What does a filtered index contain?
- Rows that meet a user-defined predicate (correct)
- Only key column values
- Non-key column values
- All rows in the table
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?
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?
Can a clustered index be filtered?
Can a clustered index be filtered?
What is the purpose of a clustered index?
What is the purpose of a clustered index?
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?
What is the drawback of using indexes?
What is the drawback of using indexes?
What is the advantage of using a clustered index?
What is the advantage of using a clustered index?
Why might indexes slow down updates, deletes, and inserts?
Why might indexes slow down updates, deletes, and inserts?
What is the purpose of INCLUDE columns in an index?
What is the purpose of INCLUDE columns in an index?
Flashcards are hidden until you start studying
