Statistics advised summary

Provides information about advised statistics. This can be used to quickly tell if the optimizer recommends creating a statistic on a column to potentially improve performance. By default, statistics are created automatically, so normally no action is necessary by the user. However, automatic statistics generation may be may be disabled by the user. For more information see the system value QDBFSTCCOL. Once the statistic is created, much more accurate estimates of the actual costs are available. Based on this new information, the optimizer may decide that there is a more efficient way to implement the SQL statement.