How to collect a TSET on a VOLATILE table

Objective :

Explain how to collect a TSET on a volatile table.
Since TSET will not currently collect information on a volatile table, first create a permanent (perm) data table and collect a TSET on the permanent table.


Environment/Conditions/Configuration

TSET will not collect data directly from a VOLATILE table.

Procedure
1.

From the session where the VOLATILE table is created, create a permanent data table.
CREATE TABLE <PERM TABLE> AS <VOLATILE TABLE> WITH DATA;

2.

Collect statistics on the perm table as was done on the VOLATILE table.
COLLECT STATISTICS
COLUMN <column 1>
[, COLUMN <column 2>]
ON <perm tablename>;

3.

Collect TSET on perm table created in step 1.
* Confirm the rewrite of the failed query used for the TSET references the new perm table, and no longer points to the VOLATILE table.

Additional Information :

Note:

Use the following to recollect statistics after statistics have been collected on a column.

COLLECT STATISTICS ON <tablename>;