Hello. You need an index on (orderingpx, serial) columns. Index on (symbol, side, orderingpx, serial) columns can't be used by order by orderingpx, serial, because such index is ordered by symbol, side, ….
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/b674d3bc-8f28-40dc-9fde-50dd7aec7c6co%40googlegroups.com.
