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