explain plans... when running in prod and dev why am I getting different results?

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I formatted your query to make it more readable. To the underlying tables have the same indexes?
Do you generate stats in the same way on both tables? Do they have a similar amount of data?
Are they they same version of Oracle. There are many factors that would affect the explain plans.
It would help to see what the differences are to know why they are different.

Do you have table partitioning in prod and not dev? How manu cores do you have in prod compared with dev?
There may be other changes that would affect the query performance. I'm guessing that you have more memory
in prod, which will limit the physical reads somewhat. You probably stripe you data across more disks as well.