Determining what column statistics exist

 

You can determine what column statistics exist in a couple of ways.

The first is to view statistics by using iSeries™ Navigator. Right-click a table or alias and select Statistic Data. Another way is to create a user-defined table function and call that function from an SQL statement or stored procedure.

 

Parent topic:

Collecting statistics with the Statistics Manager