Adding or changing table options for RUNSTATS

To add or change table options for table space statistics:

1. In the Table owner field, type the table owner name, or use the push button to search in the subsystem for a valid USER ID name.

2. In the Table name field, type the table name, or use the push button to search in the subsystem for a valid table name. The table must already exist in the table space.

3. In the Percent rows sampled for non-index columns field, specify a percentage of rows to sample. Valid values are from 1 to 100 per cent. The default is 25 per cent. Do not use this field if your table space is a LOB table space.

4. Optional: When a Table name is known (from the above field), the columns in that table are listed in the Available columns list in the Column options box. Click on a column and click the ">" push button to move a column from the Available columns list to the Selected columns list. You can move all the columns in the table with a single action if you click the ">>" push button. The reverse actions, to remove single or all columns is the "<" or "<<"push buttons. This removes colums from the Selected columns list back to the Available columns list. All columns in the Selected columns list are the columns on which statistics are gathered. You can select a maximum of 10 columns with one table space statistics operation. If you do not select any columns, then all columns are assumed.

5. Optional: You can use the Move up and Move down push buttons to re-order the selected columns.

6. Click OK to accept the values and close the window.

[Return to Partitioned Table Space Statistics task ]

[Return to Table Space Statistics task ]