16.10 - Example: User-Specified Sample Percentage - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

The following requests sample statistics on the o_orderkey with user-specified sample percentage. Statistics are collected by reading 10% of the table rows:

COLLECT STATISTICS
             USING SAMPLE 10 PERCENT
            COLUMN o_orderkey
                ON orders;