Hi there! I need help with query performance - it very slow because huge amount of data. I don't know which index will be helpful.
I have table with few columns, but query used only this:
select market_id, MAX(value) max from tickers where created_at between '2016-12-22' and '2016-12-23' group by market_id
I tried index
(market_id, created_at, value) - but it seems to be don't using by the query. Are there possibility to speedup the query by using index?
Thanks for your time!