Command Line Options for Partition Analysis Inputs to Index Wizard
The list of command line arguments for specifying the input parameters for partition analysis are described in the following table (all options are case-sensitive).
GUI Option |
Command Line options |
Remarks |
Partition name tag |
-pa <Partition Name Tag> |
<PartitionNameTag> is the name with which the partition recommendations are saved in the QCD. |
QCD Name |
-q <QCD Name> |
<QCD Name> is the QCD on which the analysis must be performed. |
Workload Name |
-w <Workload Name> |
<Workload Name> is the workload, which must be analyzed. |
Table list |
-TB "<TableName>" [{, "<TableName>"}…] |
<Table name> is the table name for which indexes have to be recommended. This is optional. |
Timelimit |
-t <Time Limit> |
<Time Limit> is the number of minutes the analysis will be performed. |