As you probably can tell, this is done automatically and not with provided scripts I can modify. The create table statement comes prior to index creation.
It seems like the phrase "CHARACTER SET" isn't recognized and somehow should be avoided when parsed. Eliran Bivas -- co-founder and editor of http://www.hungrytechies.co.il -- founder of http://www.translatethetwit.com On Mon, Feb 14, 2011 at 5:34 PM, Panayiotis Vlissidis <[email protected]>wrote: > 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. > > -- 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.
