Regresar
-
Título
Provide statistical Analysis of SQL statements and RUNSTATS commands to implement those recommendations? -
Descripción
Does Toad for DB2 and/or SQL Optimizer for DB2 provide statistical Analysis of SQL statements and provide recommended RUNSTATS commands to implement those recommendations like IBM's Data Studio? -
Resolución
In Toad for DB2:For recommended RUNSTATS (note: this does not analyze SQL statements):LUW –1) In the Object Explorer, highlight a table or index.2) On the right hand side, in the Dependencies tab, right click on a Tablespace and select Space Management | Identify Exceptionsz/OS-In the Object Explorer, right click on a Database and select Real Time Statistics Advisor.SQL Optimizer does not recommend "runstats". You can input a SQL statement and SQL Optimizer rewrites this SQL by SQL syntax changes based on current statistics. SQL Optimizer does not consider "runstats" as a solution because "runstats" may cause performance changes for all SQLs that access this table/database object. The performance changes are unpredictable, maybe some SQLs get better performance but others slow down.SQL Optimizer for DB2 LUW provides a button that users can click to perform a "runstats" after viewing the execution plan, but it is not a suggestion from SQL Optimizer.