List:General Discussion« Previous MessageNext Message »
From:Morgan Tocker Date:March 19 2014 3:27pm
Subject:Re: Precedence in WHERE clauses.
View as plain text  
Reindl,

>> The order of the WHERE clause does not matter
> 
> that is simply not true
> 
> otherwise that documentation would not exist
> http://dev.mysql.com/doc/refman/5.5/en/multiple-column-indexes.html

Yes, the order of the columns in composite indexes *does matter*.  This is a different
question to what Christophe asked.



Thread
Precedence in WHERE clauses.Christophe18 Mar
  • Re: Precedence in WHERE clauses.Michael Dykman18 Mar
    • Re: Precedence in WHERE clauses.Christophe20 Mar
      • Re: Precedence in WHERE clauses.Roy Lyseng20 Mar
  • Re: Precedence in WHERE clauses.Glyn Astill19 Mar
  • Re: Precedence in WHERE clauses.Morgan Tocker19 Mar
    • Re: Precedence in WHERE clauses.Reindl Harald19 Mar
      • Re: Precedence in WHERE clauses.Morgan Tocker19 Mar
        • Re: Precedence in WHERE clauses.Reindl Harald19 Mar
          • Re: Precedence in WHERE clauses.Morgan Tocker19 Mar
            • Re: Precedence in WHERE clauses.Christophe20 Mar
              • Re: Precedence in WHERE clauses.Christophe23 Mar
                • Re: Precedence in WHERE clauses.shawn l.green25 Mar
    • Re: Precedence in WHERE clauses.Mogens Melander19 Mar
      • Re: Precedence in WHERE clauses.shawn l.green20 Mar