- qcd_name
-
Statistics to be retrieved are found in the QCD. TableStatistics table of the specified QCD database or user.
- FOR QUERY query_ID
-
Unique identifier for the set of statistics to be found in QCD.TableStatistics.QueryId.
The default value is 0.
- SAMPLEID statistics_ID
-
Unique identifier for the given column or index in QCD.TableStatistics.StatisticsId.
- USING MODIFIED
-
Reports the modified statistics stored in QCD.TableStatistics.ModifiedStats.
If you do not specify USING MODIFIED, the database reports the unmodified statistics stored in QCD.TableStatistics.StatisticsInfo.
Example: Reporting Detailed QCD Statistics
This example requests all of the detailed QCD statistics on the employee table in database personnel from the QCD database my_qcd.
SHOW STATISTICS VALUES ON personnel.employee FROM my_qcd;