We have a clustered index in table Tbl with order of A,B,C. Does it make senses to write a query to have
WHERE A = @a, B = @b, C = @c
or it'll be as same as
WHERE C = @c, B = @b, A = @a
Does the order of query make sense for clustered index?
AND
, not commas, between the conditions inWHERE
. – ypercubeᵀᴹ Aug 7 '14 at 8:55