Generate statistics is USED to gather statistics about each table column’s proportion of duplicate values, MINIMUM values, maximum values, null values, unique values and updates the system catalog tables.

The difference between ‘generate statistics’ and ‘generate EXPRESS statistics’ is based on how the column uniqueness is calculates. The ‘generate express statistics’ calculates ESTIMATED dispersion values based on the sampling of rows in the table. ‘Generate express statistics’ uses approximation in generating the stats where as ‘generate statistics’ uses all the rows in the table.

Generate statistics is used to gather statistics about each table column’s proportion of duplicate values, minimum values, maximum values, null values, unique values and updates the system catalog tables.

The difference between ‘generate statistics’ and ‘generate express statistics’ is based on how the column uniqueness is calculates. The ‘generate express statistics’ calculates estimated dispersion values based on the sampling of rows in the table. ‘Generate express statistics’ uses approximation in generating the stats where as ‘generate statistics’ uses all the rows in the table.