DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Index merge union

Info Catalog (mysql.info.gz) Index merge intersection (mysql.info.gz) Index Merge optimization (mysql.info.gz) Index merge sort-union
 
 7.2.6.2 Index Merge Union Access Algorithm
 ..........................................
 
 The applicability criteria for this algorithm are similar to those of
 the Index Merge method intersection algorithm.  The algorithm can be
 employed when the table `WHERE' clause was converted to several range
 conditions on different keys combined with `OR', and each condition is
 one of the following:
 
    * In this form, where the index has exactly N parts (that is, all
      index parts are covered):
 
           KEY_PART1=CONST1 AND KEY_PART2=CONST2 ... AND KEY_PARTN=CONSTN
 
    * Any range condition over a primary key of an `InnoDB' or `BDB'
      table.
 
    * A condition for which the Index Merge method intersection algorithm
      is applicable.
 
 
 Here are some examples:
 
      SELECT * FROM t1 WHERE KEY1=1 OR KEY2=2 OR KEY3=3;
 
      SELECT * FROM INNODB_TABLE WHERE (KEY1=1 AND KEY2=2) OR
        (KEY3='foo' AND KEY4='bar') AND KEY5=5;
 
Info Catalog (mysql.info.gz) Index merge intersection (mysql.info.gz) Index Merge optimization (mysql.info.gz) Index merge sort-union
automatically generated byinfo2html