you can use nz_genstats script to generate the statistics.
explain plan is what we run by having explain as the first statement in the sql what we run.
EXPLAIN SELECT * FROM JOB
EXPLAIN VERBOSE SELECT * FROM JOB
EXPLAIN PLANTEXT SELECT * FROM JOB
EXPLAIN PLANGRAPH SELECT * FROM JOB
The plan files(.pln, .cpp) can be found in /nz/kit/plans for the plans which are executing currently and get moved to historical folder /nz/kit/planshist
explain plan is what we run by having explain as the first statement in the sql what we run.
EXPLAIN SELECT * FROM JOB
EXPLAIN VERBOSE SELECT * FROM JOB
EXPLAIN PLANTEXT SELECT * FROM JOB
EXPLAIN PLANGRAPH SELECT * FROM JOB
Thanks for the efforts on gathering useful content and sharing here. You can find more question and answers on Netezza database in the following forum.
ReplyDeleteNetezza database question and answers