List:General Discussion« Previous MessageNext Message »
From:Christophe Date:March 23 2014 6:34pm
Subject:Re: Precedence in WHERE clauses.
View as plain text  
Hi all,

Le 20/03/2014 13:20, Christophe a écrit :
> Hi Morgan, Harald, and all,
> 
> Thanks for the answers.
> 
> While reading your answers, I realize one more time this problem does
> not seem so obvious ... That's why I asked ;) .
> 
> Beyond the specific case I mentioned, my goal is also to get a general
> discussion about theorical behaviour of MySQL while handling WHERE clauses.
> 
> I don't have access to the application for now, but will try EXPLAIN as
> soon as I can .

Here is the Result of Explain :

http://perso.stux6.net/mysql/20140323/EXPLAIN.txt

I don't really know what is tells in details, but according to "key"
field, it seems the IDX_CS_DWProcessed key is processed first, as I'd
like it to be ...

Other question : is an INDEX on DATETIME field really useful ?

Regards,
Christophe.

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