Impact of condition order in SQL WHERE clause on performance

Does the order of condition in SQL WHERE clause affect the performance ? Is it possible to make SQL faster by changing of condition order ?
0
give a positive ratinggive a negative rating
06 Mar 2022 at 06:54 PM
Hi,

The order or conditions in SQL WHERE clause doesn't have impact on the overall performace. If you need to speed up SQL query and you are working with large database, you can try to use a temporary table.

Using of temporary tables and multiple separated queries may be faster sometimes, mainly in case of large tables.
0
give a positive ratinggive a negative rating
26 Apr 2022 at 05:57 PM
Tim
Share on FacebookShare on TwitterShare on LinkedInSend email
x
x
Follow us on Facebook
2022 AnswerTabsTermsContact us