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 Schemas within IBM® i Access Client Solutions (ACS). 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.