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.