Rajesh,

Please generate the explain plan (in dev & prod) using

explain plan for
SQL statement

properly format it and attached to your post.

Thanks,