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 ?
06 Mar 2022 at 06:54 PM
0give a positive ratinggive a negative ratingshow more
LarsLars
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.
26 Apr 2022 at 05:57 PM
0give a positive ratinggive a negative ratingshow more
TimTim
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook
2022 AnswerTabsTermsContact us