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