IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
I hope you take the time to read this posting and then realize you too are an expert and I'm looking forward to learning from you.
Added by Troy Coleman on June 25, 2016 at 1:49 — No Comments
The DB2 optimizer exploits the catalog information to choose an access path for a given SQL statement, and RUNSTATS is what populates the catalog. It is important therefore to collect a good base of statistics to give the optimizer a fighting chance of choosing well-performing access paths for your SQL.
Here we will discuss some common mistakes that are made when running RUNSTATS.…Continue