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