I'd like to get your advice about precedence in where clauses in MySQL (5.0.51, and 5.1.66 in this case / from lenny and squeeze Debian packages ).
Considering the following simple query :
SELECT * FROM Status WHERE DWProcessed = 0 AND PreviousStatus NOT IN ('PENDING', 'ACCEPTED') AND SubscribeDate < DATE_SUB(NOW(), INTERVAL 24 HOUR);
Which of these filters are processed first ?
I'd like the first filter (DWProcessed / Lowest cardinality and indexed) being processed first, but I can't really find any useful information about this .
Is there any performance impact on query processing, about the order of WHERE clauses ?
Regards, Christophe.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Mar 18
Michael Dykman Re: Precedence in WHERE clauses.
Mar 18, 2014; 15:28
Michael Dykman
Re: Precedence in WHERE clauses.
Mar 19
Glyn Astill Re: Precedence in WHERE clauses.
Mar 19, 2014; 09:49
Glyn Astill
Re: Precedence in WHERE clauses.
Mar 19
Morgan Tocker Re: Precedence in WHERE clauses.
Mar 19, 2014; 10:05
Morgan Tocker
Re: Precedence in WHERE clauses.
Mar 19
Reindl Harald Re: Precedence in WHERE clauses.
Mar 19, 2014; 15:22
Reindl Harald
Re: Precedence in WHERE clauses.
Mar 19
Morgan Tocker Re: Precedence in WHERE clauses.
Mar 19, 2014; 11:27
Morgan Tocker
Re: Precedence in WHERE clauses.
Mar 19
Reindl Harald Re: Precedence in WHERE clauses.
Mar 19, 2014; 16:36
Reindl Harald
Re: Precedence in WHERE clauses.
Mar 19
Morgan Tocker Re: Precedence in WHERE clauses.
Mar 19, 2014; 12:12
Morgan Tocker
Re: Precedence in WHERE clauses.
Mar 20
Mogens Melander Re: Precedence in WHERE clauses.
Mar 20, 2014; 00:27
Mogens Melander
Re: Precedence in WHERE clauses.
Mar 19
shawn l.green Re: Precedence in WHERE clauses.
Mar 19, 2014; 22:10
shawn l.green
Re: Precedence in WHERE clauses.
Mar 20
Christophe Re: Precedence in WHERE clauses.
Mar 20, 2014; 13:20
Christophe
Re: Precedence in WHERE clauses.
Mar 20
Christophe Re: Precedence in WHERE clauses.
Mar 20, 2014; 13:18
Christophe
Re: Precedence in WHERE clauses.
Mar 20
Roy Lyseng Re: Precedence in WHERE clauses.
Mar 20, 2014; 14:18
Roy Lyseng
Re: Precedence in WHERE clauses.
Mar 23
Christophe Re: Precedence in WHERE clauses.
Mar 23, 2014; 19:34
Christophe
Re: Precedence in WHERE clauses.
Mar 25
shawn l.green Re: Precedence in WHERE clauses.
Mar 25, 2014; 14:54
shawn l.green
Re: Precedence in WHERE clauses.
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!