Koen Verbeeck (12/2/2013)
Evgeny (12/1/2013)
What is wrong with this answer?CREATE NONCLUSTERED INDEX IDX_A ON #temp1(a)
+1
Why is this answer "incorrect"?
Flawed question today, better luck next time 🙂
It's wrong because the optimizer never use NONCLUSTERED index, if it do not need it.