Posted by Erland Sommarskog on 07/01/05 00:29

(smart_aleck72@yahoo.com) writes:
> Is there any difference in the order of parameters in the where clause?
> Does it add any speed to declare the least refined first or last?

No.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Transaction not commited rollback?
• Prev in forum: Re: SQL queries that have parameters passed by user
• Thread view: Re: stupid SQL question on Where clause

[Reply to this message]