search

jimcoly / h2database

Automatically exported from code.google.com/p/h2database
0 stars 0 forks source link

Feature Request: Partial index support #582

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
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 commented 9 years ago 
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