Query is not using Index

2011-01-18 Thread Yogesh Kore
ON px_orders.sales_order_products.order_id = px_orders.sales_orders.id WHERE px_orders.sales_order_products.status IN ( 'COMPLETED', 'CANCELED' ) AND px_orders.sales_orders.affiliate_organisation_id = 265; By explaining this query I am finding that query is not using index in table

Why the query is not using index?

2003-07-28 Thread Karam Chand
column is NULL i.e. it is not using Index? Why the query is not using index? Thanks in advance. Karam __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list

RE: Why the query is not using index?

2003-07-28 Thread Rob A. Brahier
it can check if that value is less than 500. -Rob -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 3:51 PM To: [EMAIL PROTECTED] Subject: Why the query is not using index? Greetings Having a table with the following structure