Run the EXPLAIN command to see which indexes are used for a specific query
--
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 h2-database+unsubscr...@googlegroups.co
"more than one index could be used" in that context means: the optimizer
may choose from more than one index but finally has to use only one of
theese.
To my knowledge the optimizer considers all available indexes an decides
based on the cost.
In short all indexes are used to calculate the cost a
from the H2 website:
If a table has multiple indexes, *sometimes more than one index could be
used.* Example: if there is a table TEST(ID, NAME, FIRSTNAME) and an index
on each column, then two indexes could be used for the query SELECT * FROM
TEST WHERE NAME='A' AND FIRSTNAME='B', the index o