hi i have 20 millions rows , and this index doesn't speed up the query, please help:
create index mem on data(mem, sequence); select * from data where mem is not null order by sequence mem is varchar(200); and sequence is bigint thanks -- 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/d23b4ca9-2f9b-4bbe-84dd-b7d8469e129dn%40googlegroups.com.
