Netezza/PureData – Which to Run First, Statistics or Groom?

IBM Netezza / IBM PureData for Analytics

IBM Netezza / IBM PureData for Analytics

Now, I know, this seems like a simple question, but for folks new to netezza, this question has come up more than a few times.  Also, this choice ultimately impacts how performant Netezza will be  once you complete you maintenance operations.

As a general guideline,  groom operations should be completed first, then followed by statistics operations.

Related References

Groom Table

PureData System for Analytics, PureData System for Analytics 7.2.1, IBM Netezza database user documentation, Netezza SQL command reference, GROOM TABLE

Generate Statistics

PureData System for Analytics, PureData System for Analytics 7.2.1, IBM Netezza database user documentation, Netezza SQL command reference, GENERATE STATISTICS

 

Advertisements

2 thoughts on “Netezza/PureData – Which to Run First, Statistics or Groom?

  1. Pingback: Netezza/PureData – Does a Table Truncate require a groom? | Scientia Compendium

  2. Pingback: Netezza – Useful links | Scientia Compendium

Comments are closed.