On 2013-10-14 23:07, Roger Thomas wrote:
This is a feature that I have come across on certain versions of MSSQL
and basically involves a condition clause being placed on an index and
records are only indexed if they meet the condition, so
CREATE INDEX IDXtest ON tablex (value1, value2) WHERE value2 = 2
It's on our roadmap, but being a volunteer project, is pretty much
happens when it scratches someone's particular itch :-)
If you're interested in trying to implement this, the index creation
part of it is not where the real work is.
The hard part is making the query and planner engine use 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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
