Yesterday i have tested by adding indexes on both the PROD and DEV.
Then using 10046 and 10052 trace i just generated roo execution plan on both the PROD and DEV.
I Noticed botb the tkprof files.Both the row execution plnas are showing the same.In that optimizer using index scan.
Is the number of blocks occupying by each table is same in both prod & dev? Is the recent table stats gathered??

Thanks,