(Dirk Fechner) The DB2 optimizer is a cost-based optimizer. It makes decisions based on statistics that are available for the tables and indexes. When generating statistics, DB2 offers the possibility to create so-called distribution statistics, in addition to the basic statistics. This article expl
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help