Performance: Between and Other Operators – SQL in Sixty Seconds #191

Performance: Between and Other Operators - SQL in Sixty Seconds #191 191-BetweenvsINvsOperators-YT-Final-800x450 Lots of people asked me a follow-up question after watching my earlier SQL in Sixty Seconds video on the topic of Optimize DATE in WHERE Clause – SQL in Sixty Seconds #189. The most asked question was instead of the operators if we use BETWEEN what will be the impact of performance. Let us watch Performance: Between and Other Operators.

Well, I have created a video on that topic. You may check the video yourself for the performance and also can learn why I do not prefer to use BETWEEN operator.

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 (

SQL Operator, SQL Performance, SQL Server
Previous Post
Most Used Database Files – SQL in Sixty Seconds #190
Next Post
Performance Troubles – Function on Date Variable – SQL in Sixty Seconds #192

Related Posts

Leave a Reply