Non-Usage of Indexes @ Production DB

Hi,

I have a scenario where in indexes at production db is not getting used up where as in the same scenario at the development db it is getting used up.

I have a query which @ production db is not using the indexes and performing FULL scans. The same query when executed @ development db is working fine as it is using the indexes that is created on the referenced objects.

I have crossed check on the list of indexes at production db and development db, both are same and valid.

Will ANALYSING the indexes at production db will help me out.

If anyone have better point to state, please do so.

Anyone can put some thoughts to the subject

If there are different stats, data volumes and distributions in the the two systems, the optimizer might come up with different execution plans.

Everything needs to be analyzed to enable the optimizer to make the right decisions.