12 Questions
What type of index contains the physical locations of the rows in the table?
Non-clustered index
In what form does the base data exist if a non-clustered index is separate from it?
Heap
What does a filtered index contain?
Rows that meet a user-defined predicate
Which type of index can contain copies of non-key column values at the leaf level of the index tree?
Include index
What happens if values from columns not in the non-clustered index are requested?
The query uses the clustered index
Can a clustered index be filtered?
No, it has to contain all the data in the table
What is the purpose of a clustered index?
To represent the base data as a whole in a specific order
Why might a non-clustered index take longer for a query on Employee2 compared to Employee1?
Employee2 is a physically separate structure with different sort order
What is the drawback of using indexes?
Indexes consume additional storage space
What is the advantage of using a clustered index?
Fast access through a tree structure
Why might indexes slow down updates, deletes, and inserts?
They have to be updated along with the data
What is the purpose of INCLUDE columns in an index?
To speed up data retrieval for specific columns in queries
Test your knowledge about non-clustered indexes and their impact on database performance. Explore topics such as the relationship between non-clustered indexes and base data, references back to the base data, and the comparison of non-clustered index with clustered index in terms of performance.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free