SQL$HELP72.HLB  —  INSERT  Arguments  OPTIMIZE_WITH
    Selects one of three optimzation controls: DEFAULT (as used by
    previous versions of Rdb), AGGRESSIVE (assumes smaller numbers of
    rows will be selected), and SAMPLED (which uses literals in the
    query to perform preliminary estimation on indices).

    The following example shows how to use this clause.

    SQL> select * from employees where employee_id  > '00200'
    cont>   optimize with sampled selectivity;
Close Help