title: SQL Query Performance with BETWEEN AND Vs GTE/LTE
body: <p>In <strong>SQL</strong> we have these 2 function to retrieve data in range, I am using this on datetime field and trying to retrieve data for last 4 years.</p>
  
  <p>Just wanted to confirm which is better in terms of query performance out of <strong>BETWEEN...AND</strong> or     <strong>>=</strong> .</p>
  
  <p>My final result row count is 200000 and it is has grouping, overall execution time is 3 minutes.</p>