Martin Gainty wrote:
Andrew et al-
Keep in mind that when you use LIKE you will NOT use an index but you will use a full table scan instead.
Agreed.
Also instead of using IN EXISTS uses Indexes on the master table query..if you have master-heavy or parent-heavy query use EXISTS/NOT EXISTS vs IN/NOT IN
http://archives.postgresql.org/pgsql-performance/2002-12/msg00185.php
It's not clear to me how that post is relevant. First, I'm uncertain of its accuracy. (The author clearly does not understand LEFT JOINs.) Second, I'm not sure it applies to mysql. Third, it's about subqueries, but there were no subqueries in this thread.
HTH, Martin Gainty
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
