I've got a large table with, amongst other things, two indexed varchar fields. Individual queries, SELECT count(*) FROM orders WHERE email != 'control'; is fast (0.01 sec), and SELECT count(*) FROM orders WHERE distdate LIKE '07/%/2001'; is fast (0.02 sec). But, SELECT count(*) FROM orders WHERE distdate LIKE '07/%/2001' AND email = 'control'; is very slow. I can't think of any way to speed up the query. Is there some way I can index it so it will work faster? Thanks. Age --------------------------------------------------------------- Adriano "Age" Manocchia [EMAIL PROTECTED] SalsaSharkNet AIM/Yahoo/MSN: SalsaSharkNet http://SalsaShark.Net/age ICQ: 5962736 --------------------------------------------------------------- "The capacity to blunder slightly is the real marvel of DNA. Without this special attribute, we would still be anaerobic bacteria, and there would be no music." -Lewis Thomas --------------------------------------------------------------------- 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
