Also see our documentation here:

On 18 September 2016 at 00:56, Alan Darkworld <>

> indexing, and I would be very interested in learning how that works on a
> conceptual level. In particular, I am interested in the case of non-unique
> indices. What is the key in this case, and what is the value?

A secondary index is just a map from the index key -> list of row ids

> How are queries (e.g. "name like '%Eva%'") executed on such an index?
> Queries like that always require scanning over either the table itself, or
if the column is present in an index, it is cheaper to scan over the index.

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 post to this group, send email to
Visit this group at
For more options, visit

Reply via email to