Hi, Found in the web page(h2) the following guide: *The SQL statement ANALYZE can be used to automatically estimate the selectivity of the columns in the tables. This command should be run from time to time to improve the query plans generated by the optimizer.*
*My question is:* should I have scheduler task in my app running analyze on each of my queries every X sec? If do then : ======== 1. For which query to use it? is it only for complex queries? For example I use select with *Left_outer_join* with *where* holding multiple conditions. Each conditions has a separate index. 2. How often to use it? ( every min? every hour? ) 3. What the exact effect? 4. Could it effect my service? does it effects runtime responsive? 5. What damage will happen when not using it? thx Elad Wertzberger -- This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this on behalf of the addressee you must not use, copy, disclose or take action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Thank you. -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
