Thread: greater than vs between in where clause
May i know if there is a difference in speed between 1 ,2 and 3 below , if column start_date is indexed
1. select * from table_1 where start_date > '1 Oct 2020'
2. select * from table_1 where start_date between '1 Oct 2020' and now()
3. select * from table_1 where start_date between '1 Oct 2020' and '5 Nov 2020 23:59:59'
On 11/5/20 6:49 AM, Yambu wrote: > May i know if there is a difference in speed between 1 ,2 and 3 below , > if column start_date is indexed > > 1. select * from table_1 where start_date > '1 Oct 2020' > 2. select * from table_1 where start_date between '1 Oct 2020' and now() > 3. select * from table_1 where start_date between '1 Oct 2020' and '5 > Nov 2020 23:59:59' Run EXPLAIN ANALYZE(https://www.postgresql.org/docs/13/sql-explain.html) on each and let us know. -- Adrian Klaver adrian.klaver@aklaver.com