I found the blowing query: select * from "order" where symbol = ? and side = ? returns results have already ordered by `orderingpx, serial`, it that a definite behavior? can I trust it.
On Monday, July 6, 2020 at 8:03:22 PM UTC+8, Evgenij Ryazanov wrote: > > 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/dda541db-589d-4f49-99e1-976499f653afo%40googlegroups.com.
