IBM Db2 11.1 Certification Guide

The RUNSTATS Utility

This utility command can use be used to collect table and index statistics to build efficient access plans. The basic command syntax for RUNSTATS is:

    RUNSTATS ON TABLE [TableName]
    USE PROFILE
    <UTIL_IMPACT_PRIORITY [Priority]>

You could also use this version of the command:

    RUNSTATS ON TABLE [TableName] FOR
    <<SAMPLED> DETAILED>
    [INDEXES | INDEX]
    [[IndexNames] | ALL]
    <EXCLUDING XML COLUMNS>
    <ALLOW READ ACCESS | ALLOW WRITE ACCESS>
    <SET PROFILE NONE | SET PROFILE <ONLY> | UPDATE PROFILE
        <ONLY>>
    <UTIL_IMPACT_PRIORITY [Priority]>

You could also use this version of the command:

    RUNSTATS ON TABLE [TableName]
    <ON ALL COLUMNS |
        ON KEY COLUMNS> |
        ON COLUMNS [ColumnNames] |
        ON ALL COLUMNS AND COLUMNS [ColumnNames] |
     ON KEY ...