Question & Answer
Question
How do I find the execution plan for a query?
Answer
Would you like to know an easy way to retrieve the execution plan for a query? Use the nz_plan utility. With this utility, you do not have to know the exact directory where your plan file is located. Also, the output of this utility tells you if statistics are up to date on the tables used in the query.
To run it, change to the /nz/support/contrib/bin directory and run nz_plan plan_name (for example, nz_plan 1234). You can also redirect the output to a file:
- nz_plan 1234 > p1234.pln.
Refer to What information do I need to collect to report a slow performing query?, referenced below, for more information on the nz_plan utility.
Related Information
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
NZ092536
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21577042