Zensar Technologies interview question
How do you optimise a SQL query
Interview Answer
Anonymous
28 May 2016
Declaring indexes, running stats on the tables, creating non clustered indexing, Using Union All instead of Union and enforcing a Where clause.