Eliran,
Sorry, i didn't get your question on script and CHARACTER SET.
if you are taking about \n\t\t, the sql scripts are externalized in
the a config file. It has new lines and tabs in the query.
Thanks,
Suresh
On Feb 14, 8:38 pm, Eliran Bivas <[email protected]> wrote:
> 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 ofhttp://www.hungrytechies.co.il
> -- founder ofhttp://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-c...
>
> > 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.
