Also see our documentation here: http://h2database.com/html/mvstore.html

On 18 September 2016 at 00:56, Alan Darkworld <alandarkwo...@gmail.com>
wrote:

> 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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to