On Wed, Mar 20, 2002 at 12:17:58AM -0700, zxcv wrote: > > An Oracle DB programmer reviewed a query that I wrote and told me > that putting constants at the beginning of the query would make it > slower. I thought I'd go to the experts on MySQL and be told the > truth one way of the other.
Perhaps he's used to a database where the optimizer is easily fooled? The MySQL optimizer is very smart. It rarely is tricked by chaning the order of columns in the WHERE clause. Try it and see. :-) Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 40 days, processed 1,205,188,115 queries (342/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
