Re: greater than vs between in where clause

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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@xxxxxxxxxxx