Indexing

[UKuser]

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

[Captain Paralytic]

On 30 Jan, 09:13, UKuser <[e-mail]:

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

This has nothing to do with php.