|
|
Posted by UKuser on 01/30/08 09:13
Hi Folks,
Having some wierd problems with indexing in my query. If I run the
following
explain
select basket.*, companies.Company_ID as Company_ID
from basket
inner join companies on basket.Company_ID=companies.Company_ID
where
basket.`Status`='Open'
An index is used for companies.Company_ID and basket.Status. The
minute I try to pull anything else through from the companies table
(i.e.:
select basket.*, companies.Company_ID as Company_ID, companies.Name)
It won't use the Company_ID index, even though the inner join is using
it. Why is that?
Any help or direction to investigate would be great.
Many thanks
A
Navigation:
[Reply to this message]
|