SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-272
Examples of UPDATE STATISTICS
•
This example generates statistics for a sample from table MAILINGS. The sample
size is 7.3529 percent and the number of rows in the table is 272,000. The records
that are selected by sampling are stored in a temporary table,
MY_SAMPLE_TABLE, which is specified by the user. The data in the temporary
table is then used to generate the statistics.
UPDATE STATISITCS FOR TABLE MAILINGS
ON EVERY COLUMN
SAMPLE RANDOM 7.3529 PERCENT CLUSTERS OF 1 BLOCKS
SET ROWCOUNT 272000
USING SAMPLE TABLE MY_SAMPLE_TABLE;
For additional examples, see the SQL/MX Query Guide.