SQL$HELP72.HLB  —  ALTER  INDEX  Format
  (B)0ALTER INDEX <index-name> qqqqqqqk                                    
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj                                   
  mqqqwq> add-partition-clause qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>
      tq> BUILD PARTITION <partition-name> qqqqqqqqqqqqqqqqqqqqqqqqqu 
      tq> BUILD ALL PARTITIONS qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
      tq> DROP PARTITION <partition-name> qqqqqqqqqqqqqqqqqqqqqqqqqqu  
      tq> MOVE PARTITION <partition-name> TO area-spec   qqqqqqqqqqqu  
      tq> REBUILD PARTITION <partition-name> qqqqqqqqqqqqqqqqqqqqqqqu
      tq> REBUILD ALL PARTITIONS qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
      tq> RENAME PARTITION <partition-name> TO <new-partition-name> u  
      tq> TRUNCATE PARTITION <partition-name> qqqqqqqqqqqqqqqqqqqqqqu
      tq> TRUNCATE ALL PARTITIONS qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu
      mq> alter-index-attributes qwqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqj  
                                  mq> index-store-clause qqj           
                                                                       

  (B)0add-partition-clause =

  q> ADD PARTITION <partition-name> qqqk
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
  mq> USING q> ( qwq> <column-name> qwq> ) qk
                  mqqqqqqq , <qqqqqqqj      x
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
  mq> IN area-spec qqqqqqqqqqqqqqqqqqqqqqqqqk
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
  mqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>
     mq> WITH LIMIT OF q> ( qwq> <literal> qwq> ) qqj    
                             mqqqqqq , <qqqqj            

  (B)0area-spec =                                                                
                                                                             
  qq> <area-name> qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>   
                   mq> ( qwwq> threshold-clause qqqqqqqqqqqqqqqwwq> ) qj     
                          xtq> LOGGING qqqqqqqqqqqqqqqqqqqqqqqqux            
                          xtq> NOLOGGING qqqqqqqqqqqqqqqqqqqqqqux            
                          xtq> PARTITION <name> qqqqqqqqqqqqqqqux            
                          xmq> COMMENT IS qwqq> 'string' qqqwqqjx            
                          x                mqqqqqqq / <qqqqqj   x            
                          mqqqqqqqqqqqqqqqq ,  qqqqqqqqqqqqqqqqqj            

  (B)0alter-index-attributes=

  qwqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwq>
   x tq> threshold-clause qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x
   x tq> DUPLICATES ARE ALLOWED qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x
   x tq> LOGGING qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x
   x tq> NOLOGGING qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x
   x tq> NODE SIZE <number-bytes> qqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x
   x tq> PERCENT FILL <percentage> qqqqqqqqqqqqqqqqqqqqqqqqqqqqu x
   x tq> PREFIX CARDINALITY COLLECTION IS qwq> ENABLED qqqqqqwqu x
   x x                                     tq> ENABLED FULL qu x x
   x x                                     mq> DISABLED qqqqqj x x
   x tq> USAGE qwq> UPDATE qwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu x
   x x          mq> QUERY qqj                                  x x
   x tq> COMMENT IS qwq> '<string>' qqwqqqqqqqqqqqqqqqqqqqqqqqqu x
   x x               mqqqqq / qqqqqqqqj                        x x
   x mq> MAINTENANCE IS qwq> DISABLED qqqqqqqqqqqqqqqqqwqqqqqqqj x
   x                     mq> ENABLED qwqqqqqqqqqqqqqqwqj         x
   x                                  tq> DEFERRED qqu           x
   x                                  mq> IMMEDIATE qj           x
   mqqqqqqqqqqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj

  (B)0threshold-clause =                                           
                                                               
  qqwq> THRESHOLD qwq> IS qwq> ( qq> <val1> qq> ) qqqqqqqqqwq> 
    x              mq> OF qj                               x   
    x                                                      x   
    mq> THRESHOLDS qwq> ARE qwqqqqqqqqqqqk                 x   
                    mq> OF  qj           x                 x   
      lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj                 x   
      mq> ( qq> <val1> qwqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> ) qj   
                        mq> , <val2> qwqqqqqqqqqqqqqu          
                                      mq> , <val3> qj          
                                                               

  (B)0index-store-clause =                                                
                                                                      
  STORE qqqqqqqqqqqqqqqqqqqqqqk                                       
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqj                                       
  mwq> IN area-spec qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqw>   
   mq> USING q> ( qwqq> <column-name> qwq> ) qqqqqqqqqqk         x    
                   mqqqqqqq , <qqqqqqqqj               x         x    
   lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj         x    
   mw> IN area-spec qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk       x  
    x lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj       x    
    x mq> WITH LIMIT OF q> ( qwqq> <literal> qwq> ) qqqwqqqk     x    
    x                         mqqqqqq , <qqqqqj        x   x     x    
    mqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqj   x     x    
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj     x    
  mwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwj    
   mq> OTHERWISE IN area-spec qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj     
Close Help