Hello,
I am no expert but I think that creating multi-column indexes based on the
combination of columns that appear in the where clause could help
improve the performance of your queries.
e.g. (based on the SQL you provided)
CREATE INDEX IF NOT EXISTS comb_index_name
ON CURRENT_VALUES(ATT2 , ATT3, ATT4, ATT5, ATT9)
Also take have a look here which has a lot of interesting info about
indexes(although
original question is directed to SQL Server):
http://stackoverflow.com/questions/179085/multiple-indexes-vs-multi-column-indexes
I'm guessing that Thomas could be of more help since he knows the ins
and outs of H2
Best regards,
Panayiotis Vlissidis
P.S: Please let me know how that works in case you try it.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
