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
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
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