Search Postgresql Archives

greater than vs between in where clause

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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'

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux