From https://www.h2database.com/html/performance.html:
This database uses indexes to improve the performance ofSELECT, UPDATE,
DELETE. If a column is used in the WHERE clause of a query, and if an
index exists on this column, then the index can be used. Multi-column
indexes are used if all or the
Greetings!
As far as I remember, H2 considers composite indices only in certain
situations -- but not for all possible optimisations.
Please EXPLAIN your query to check, if the index has been considered (I
guess, it has not).
Maybe try again with 2 different indices, one for MEM and one for
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