Do you have a question? Post it now! No Registration Necessary. Now with pictures!
January 30, 2008, 9:13 am
rate this thread
Having some wierd problems with indexing in my query. If I run the
select basket.*, companies.Company_ID as Company_ID
inner join companies on basket.Company_ID=companies.Company_ID
An index is used for companies.Company_ID and basket.Status. The
minute I try to pull anything else through from the companies table
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.