sql query too slow

Posted 1 month ago by arctushar

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

  1. search by date
  2. search by created_at
  3. search by id range ( I will make a table for id range for specific date. then from that table collect id start and end from specific date. and query for id range)

Please suggest which is best way between above 3 methods.

Please sign in or create an account to participate in this conversation.