221
SQL Server Interview
Advanced Indexing
SQL Server interview questions covering advanced indexing.
20 Questions Filter by level
Interview questions
Open a question for the full answer, code and interview guidance.
222
What characteristics make a good clustered index key?
223
What happens when a clustered index key is not unique?
224
What is a page split?
225
What is fill factor?
226
What is index depth?
227
Why are narrow index keys generally preferred?
228
What is the difference between key columns and INCLUDE columns?
229
How do you decide the order of columns in a composite index?
230
Can SQL Server use a composite index if the first key column is not filtered?
231
What is an index intersection?
232
What is an index spool?
233
What are missing-index recommendations?
234
How do you identify unused or rarely used indexes?
235
What are duplicate and overlapping indexes?
236
What is a columnstore index?
237
What is the difference between rowstore and columnstore indexes?
238
What is an indexed computed column?
239
When should an index be dropped?
240