I have sql table with 2,685,222 rows and have below columns
id, codelist_id, ltp, trade, value, volume, date, time, created_at, updated_at.
Now When I search something by date, taking too much time. Plz suggest which is faster from below method
Please suggest which is best way between above 3 methods.