Posted on Thursday, 9th October 2008 by Balazs
One of the challenges in query optimization is to make sure that the query optimizer works with accurate estimates on cost of the different possible decision branches in the optimization process. The accuracy of the estimates depends on the efficiency of the stats collection.
DB2 assumes the data distribution is constant distribution. And that’s why [...]
Tags: DB2, IBM, QUERY OPTIMIZATION, RUNSTATS
Posted in DB2 | Comments (Comments)