Hi everyone,

out of personal interest I am studying a variety of persistence techniques. 
Among them, the H2 MVStore has drawn my attention a lot lately. I can see 
how to use the key-value store format to store relational data - the key is 
the row ID and the value is the serialized form of all column values that 
belong to that row. So far, so good for the primary index. However, in the 
post <https://groups.google.com/forum/#!topic/h2-database/k9sZCS12pvo>, the 
author said that it will also be used for secondary 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? How are queries (e.g. "name like 
'%Eva%'") executed on such an index?

Perhaps someone from the H2 engineering team is reading this and is kind 
enough to provide some insight.

Thank you,

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