To be honest I would not know where to start - my background is more database systems than programming.
Roger On Wednesday, October 16, 2013 3:00:45 PM UTC+1, Noel Grandin wrote: > > > 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.
