Advertisements
PureData Powered by Netezza
I had a question today while considering the way to [potentially improve performance and stability of my ETL’s. Basically, does Netezza need to be groomed when truncating a table as part of a destructive load strategy? The answer is no, a Netezza table does not need to be groomed after a truncate operation—see IBM Tip quoted below.
Tip: When you delete all the contents of a table, consider using the TRUNCATE command rather than the DELETE command, which eliminates the need to run the GROOM TABLE command.”
Once the data is loaded, following the truncate, running Generate Statistics on the table is strongly recommended.
.
Related References
- Netezza – Useful links
- Netezza / PureData – Table Effective Practices
- PureData – CURRENT_TIMESTAMP Function
- Netezza/PureData SQL Date Formatting Examples
- Netezza – How GET to Database UTC Offset With SQL
- Netezza/PureData – Which to Run First–Statistics or Groom?
- Netezza/PureData – Dictionary Views
- Netezza/PureData – Table Distribution Key Practices
2 thoughts on “Netezza/PureData – Does a Table Truncate require a groom?”