SQL$HELP72.HLB  —  ALTER  INDEX  Arguments  USAGE
    Syntax options:

    USAGE UPDATE | USAGE QUERY

    Specifies a PERCENT FILL value appropriate for update-intensive
    or query-intensive applications. You cannot specify this argument
    in an ALTER INDEX statement that refers to a hashed index. The
    USAGE UPDATE argument sets the PERCENT FILL value at 70 percent.
    The USAGE QUERY argument sets the PERCENT FILL value at 100
    percent.

    You should specify either the PERCENT FILL or USAGE clause, but
    not both.
Close Help