Re: [h2] Re: Plan to support second index key?

Hi, The MVStore supports multiple maps. To add an index for a map, simply add another map. This is how the H2 database (the relational part of H2 with SQL API) uses the MVStore. Example: Map customers = ... // key: customer id; value: customer data Map

[h2] Re: Plan to support second index key?

Sorry, I mean MVStore which is key value feature... Thanks On Thursday, April 26, 2018 at 9:23:50 AM UTC+8, Evgenij Ryazanov wrote: > > Hello. > > What exactly do you mean by second index key? Indexes are not a part of > SQL standard, but almost all databases have them and many databases have

[h2] Re: Plan to support second index key?

Hello. What exactly do you mean by second index key? Indexes are not a part of SQL standard, but almost all databases have them and many databases have very similar syntax. Berkeley's own documentation have SQL examples. The complete H2's syntax can be found here: