Tag Archives: query plan

Preserving plan files with rsync

Anytime you’ve wanted to investigate the execution plan of a query that ran days (or even hours) ago, you’ve probably found yourself disappointed that the plan file is no longer there.  That’s because Netezza only keeps a few thousand plans … Continue reading

Posted in administration, General, Performance | Tagged , | Leave a comment