SQL$HELP_OLD72.HLB  —  DELETE  Format
  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> -----------------------+ |
                   +---------------- <----------------------------+
Close Help