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:_e({}, > 'cvml', 'h2-database%[email protected]');>. > To post to this group, send email to > [email protected]<javascript:_e({}, 'cvml', > '[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.
