Netezza/PureData – Does a Table Truncate require a groom?

Netezza/PureData – Does a Table Truncate require a groom

PureData Powered by Netezza

I had a question today, while considering way to [potentially improve performance and stability pf 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

Generate Statistics

PUREDATA SYSTEM FOR ANALYTICS, PUREDATA SYSTEM FOR ANALYTICS 7.2.1, IBM NETEZZA DATABASE USER DOCUMENTATION, NETEZZA SQL COMMAND REFERENCE, GENERATE STATISTICS

Groom Table

PUREDATA SYSTEM FOR ANALYTICS, PUREDATA SYSTEM FOR ANALYTICS 7.2.1, IBM NETEZZA DATABASE USER DOCUMENTATION, NETEZZA SQL COMMAND REFERENCE,GRoom table

Truncate

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

 

 

2 thoughts on “Netezza/PureData – Does a Table Truncate require a groom?

  1. Pingback: PureData – Table Effective Practices | Scientia Compendium

  2. Pingback: Netezza – Useful links | Scientia Compendium

Comments are closed.