added [query-performance] to 2412 questions - Shog9 (Id=1924)

Link

edited Jan 7, 2020 at 22:23

added 4 characters in body

Source Link

edited Aug 7, 2014 at 8:55

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

WHERE A = @a, B = @b, C = @c

or it'll be as same as

... WHERE C = @c, B =@b, A =@a.

WHERE C = @c, B = @b, A = @a

Does the order of query make sense for clustered index?

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?

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?

Source Link

asked Aug 7, 2014 at 8:05

Does it make sense to order condition in where query?

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?

Return to Question