No, but if you can create a small self contained test case, we can attempt to find a solution.
On Saturday, 20 April 2013, Niko Paltzer wrote: > 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]<javascript:;>> > 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] <javascript:;>. > >> > >> To post to this group, send email to > >> [email protected]<javascript:;> > . > >> 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] <javascript:;>. > > To post to this group, send email to > > [email protected]<javascript:;> > . > > 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] <javascript:;>. > To post to this group, send email to > [email protected]<javascript:;> > . > 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.
