Feature Request: Partial index support

[GoogleCodeExporter]

It would be nice if H2 supported the creation of partial indexes.

In some situations these can lead to significant performance improvement and 
reduced storage requirements.

See the documentation for SQLite and Postgresql for details:

https://www.sqlite.org/partialindex.html

http://www.postgresql.org/docs/current/interactive/indexes-partial.html

Original issue reported on code.google.com by thilopl...@googlemail.com on 5 Sep 2014 at 9:24

[GoogleCodeExporter]

Yes, that would be a nice addition. Please note H2 currently adds _all_ rows to 
each index, that is, even if the index column is null.

Original comment by thomas.t...@gmail.com on 5 Sep 2014 at 12:39

• Changed state: PatchesWelcome