Hi I have some simple questions. 1. have u used index. 2. when you run a query do you use sub-queries. 3. when you run a query do you use joins. 4. what is your data size. 5. could you give some details as to how many columns you use per table.
Thanking you Regds - K. Prakash On Wed, Sep 29, 2010 at 10:16 PM, Sudharsan Gunanathan <[email protected]>wrote: > Hi, > > Is there a way to specify hints to the query optimizer? Currently > my queries are running slow as the optimizer is choosing the wrong > indices. This would really help me gain some performance improvements. > Thanks a ton in advance. > > Thanks, > Sud. > > -- > 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]<h2-database%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- Keep in Touch Prakash [email protected] -- 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.
