DELETE FROM --+-> <table-name> ---+-+-----------------------+-+ +-> <view-name> ----+ +-> <correlation-name> -+ | +-------------------------------------------------------------+ ++--------------------------------------------------------+----> +-> WHERE -+-> predicate --+---------------------------+-+ | +> optimize-clause ---------+ | +-> CURRENT OF <cursor-name> -----------------+ optimize-clause = --+---------------------------------------------------------------+---> +-> OPTIMIZE --+-+-> FOR -+-> FAST FIRST --------+----------+-+-+ | | +-> TOTAL TIME --------+ | | | | +-> SEQUENTIAL ACCESS -+ | | | +-> USING <outline-name> ------------------+ | | +-> WITH -+-> DEFAULT --+-> SELECTIVITY -+ | | | +-> SAMPLED --+ | | | | +-> AGGRESSIVE + | | | +-> AS <query-name> -----------------------+ | +---------------- <----------------------------+