大家好，
Hi all,
select sku,itemTitle,vendorID,UPC from portal_orders where purchaseDate<='2012-11-13' and sku not in (select sku from portal_orders where purchaseDate<='2012-12-13' and purchaseDate>='2012-11-13' group by sku)and vendorID=$where2 limit 5如何简化此查询..此查询需要更多时间来执行
How can i simplify this query.. this query takes more time to execute
推荐答案where2 limit 5 where2 limit 5
如何简化此查询..此查询需要更多时间来执行
How can i simplify this query.. this query takes more time to execute
可能是对你有用： www.databasejournal/features/mysql/article.php/1382791/Optimizing-MySQL-Queries-and-Indexes.htm [ ^ ] Could be useful for you : www.databasejournal/features/mysql/article.php/1382791/Optimizing-MySQL-Queries-and-Indexes.htm[^]