So I'm doing this query
select * from table where time>'2019-01-28 04:13:36.790000' and time<'2019-01-28 04:13:46.790000';
It used to be very fast, but as the table grew it's now taking several minutes to complete. I'm not exactly sure how many entries are in the table. I'm guessing tens of millions. I just want to be able to query entries in a given time interval. Is there anything I can do to the table to make this quicker.