net-questdb-client icon indicating copy to clipboard operation
net-questdb-client copied to clipboard

[FEATURE] Possibility to specify secondary index for `Symbol`

Open enricobenedos opened this issue 4 months ago • 3 comments

We started using QuestDb in our production environment to store also historical EOD market data. About that we are experiencing slow queries when asking for "the first available data for that symbol":

SELECT * FROM eod_1d_raw 
WHERE identifier = 'BBG000BDTBL9'
LIMIT 0,1

so we tried to add the index for symbol column and now we are performing some tests (even if it seems that it doesn't solve the performance problem).

Shortly we recreate the eod_1d_raw table every day and now we need to create the associated index also.

Can you please add a way to specify we want the symbol index on table creation extension methods chain?

enricobenedos avatar Oct 04 '24 08:10 enricobenedos