Hi! Thanks for reply, this is the original query plan:
I did a big table with more then 600mln of rows (more assets combined) and running that query takes more then 5sec (i9-12th)…
I’ve add your suggestion to include also a lower bound in WHERE clause and same query runs now in 400ms, this is a huge improvement and I might consider to move again into a single table if performances will be costant even if table increases to let’s say 2/3 billions of rows
I’d like to try your other suggestion removing the index (the symbol) but not sure how to test