Posted by Captain Paralytic on 01/30/08 10:05

On 30 Jan, 09:13, UKuser <spiderc...@yahoo.co.uk> wrote:
> 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.

[Back to original message]