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.
