Library /sys$common/syshlp/SQL$HELP72.HLB  —  DELETE  Format
  (B)0DELETE FROM qqwq> <table-name> qqqwqwqqqqqqqqqqqqqqqqqqqqqqqwqk  
                mq> <view-name> qqqqj mq> <correlation-name> qj x  
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj  
  mwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqq> 
   mq> WHERE qwq> predicate qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqwqu      
              x               m> optimize-clause qqqqqqqqqj x      
              mq> CURRENT OF <cursor-name> qqqqqqqqqqqqqqqqqj      
                                                                   

  (B)0optimize-clause =                                                 
                                                                    
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqq> 
    mq> OPTIMIZE qqwqwq> FOR qwq> FAST FIRST qqqqqqqqwqqqqqqqqqqwqwqj     
                   x x        tq> TOTAL TIME qqqqqqqqu          x x       
                   x x        mq> SEQUENTIAL ACCESS qj          x x
                   x tq> USING <outline-name> qqqqqqqqqqqqqqqqqqu x 
                   x tq> WITH qwq> DEFAULT  qqwq> SELECTIVITY  qu x
                   x x         tq> SAMPLED  qqu                 x x
                   x x         mq> AGGRESSIVE j                 x x
                   x mq> AS <query-name> qqqqqqqqqqqqqqqqqqqqqqqj x 
                   mqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqqqj 
                                                                    
Close Help