121
SQL Server Interview
Indexes & Query Performance
SQL Server interview questions covering indexes & query performance.
20 Questions Filter by level
Interview questions
Open a question for the full answer, code and interview guidance.
122
What is a clustered index?
123
What is a nonclustered index?
124
What is the difference between clustered and nonclustered indexes?
125
What is a heap in SQL Server?
126
What is a composite index?
127
Why does column order matter in a composite index?
128
What are included columns in an index?
129
What is a covering index?
130
What is a filtered index?
131
What is index selectivity?
132
What is an execution plan?
133
What is the difference between an Index Seek and an Index Scan?
134
What is a Key Lookup?
135
What is a SARGable query?
136
What are statistics in SQL Server?
137
What is index fragmentation?
138
What is the difference between REORGANIZE and REBUILD?
139
What is parameter sniffing?
140