Hi Noel, thank you for the hint. Do you happen to have any idea what it could be?
Any test I could do? Cheers, Niko On Fri, Apr 19, 2013 at 6:12 PM, Noel Grandin <[email protected]> wrote: > H2 does not cache execution plans for views. > > So something else must be at work. > > > On Friday, 19 April 2013, Niko Paltzer wrote: >> >> Hi, >> >> I have a view in my H2 with an execution plan that is very slow for the >> data present in the database. select * from view takes 150 seconds. >> >> If the select-statement of the view es executed separately, the H2 chooses >> a better execution plan. select * takes less than a second. >> >> If I drop and recreate the view, the better plan is chosen for it, too. >> >> Is there a possibility to update the execution plan for the view without >> recreating the whole view? >> >> The version is 1.3.167. >> >> Best regards, >> Niko >> >> -- >> 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?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "H2 Database" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/h2-database/DNEabd0fqSo/unsubscribe?hl=en. > To unsubscribe from this group and all its topics, 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?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
