I have a query of 18 table joins and it utilizes the Indexes in Development Database but it does not use the Indexes in QA and Production Database even though Tablea are the same, Indexes are the same and Same Types.

Logically Every thing is same in all three databases but Query Does not use the Indexes in QA and Production but works fine in Development..

Can any one let me know WHY?

Please respond me ASAP.. at [email protected]

Thanks.