This command lists the latest versions of all plans.
Table 9–5 Arguments and Result for the pdb.p.la Command
Argument/Result |
Syntax |
Description |
|
---|---|---|---|
sh |
[O] |
Boolean |
Whether hidden plans are shown. Default is false |
cat |
[O] |
CategoryID |
Category filter to apply. Default is “all”. |
folderID |
[O] |
FolderID |
Parent folder ID; default is the root folder (NM:/) |
flatView |
[O] |
Boolean |
Whether to display results in flat view; defaults to true |
result |
ExecutionPlanArray |
The execution plans |