Optimize DATE in WHERE Clause – SQL in Sixty Seconds #189

During Comprehensive Database Performance Health Check, I often get questions about how to Optimize DATE in the WHERE Clause. Let us learn about it today.

Every time there is a function applied on the column used in the WHERE clause, there is a good chance that there is performance degradation as the entire column has to be converted first before the comparison operation happens. However, there is a good chance that if you are using DATE in the WHERE clause, you can optimize that particular query by just re-arranging the conditions. We will be focusing on how to Optimize DATE in the WHERE Clause in this blog post.

Here are my few recent videos and I would like to know what is your feedback about them. Do not forget to subscribe SQL in Sixty Seconds series. I hope you appreciate learning about the last few SQL in Sixty Seconds Video.

If you have any questions, you can always reach out to me on Twitter.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Exit mobile version