IBM Netezza or Puredata Systems uses the cost based optimizer to determine best methods determine redistribution, scan, join, join orders. Optimizer uses statistics to generate optimal execution plan. You need collect statistics on tables or databases regularly. In my other post, Netezza Generate Statistics: A Guide and Best Practices, we have discussed some of best practices to generate statistics on Netezza tables. In this post, we will discuss different methods to display Netezza table statistics with some examples. What Are Table Statistics? Tables statistics are nothing but information about each column…

The Netezza nzstats command allows you to view sets of related operational information that is, statistics on the tables. These sets are organised as groups of related statistics or tables that contain rows of related statistics. The statics are very much important in Netezza appliances. System uses the up-to-date stat information to plan and execute the queries. Netezza appliance works better if the system catalog tables have up-to-date stats. Displaying System Statistics using Netezza nzstats Command The Netezza nzstats command displays operational statistics about system capacity, system faults, and system…