Hi Venkat & Ragav,
Thanks for your reply.
Below are the details as requested.

IN PROD
=========
DATABASE VERSION:10.2.04
OS:SUN SOLARIS SPARC
OPTIMIZER MODE:10.2.03
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "TEST"."CONTRACT_TRANS" 2.506 MB 99432 rows
. . imported "TEST"."CONTRACT_TRANS_GROUP" 1.476 MB 30276 rows

IN DEV
============
DATABASE VERSION:10.2.04
OS:SUN SOLARIS SPARC
OPTIMIZER MODE:10.2.03
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "TESTDEV"."CONTRACT_TRANS" 2.506 MB 99432 rows
. . imported "TESTDEV"."CONTRACT_TRANS_GROUP" 1.476 MB 30276 rows

Yes we are passing the same bind variables on both the PROD and DEV databases.

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.

But without index i.e using full table scan the row exection plan was showing different.Is anything prameter setting missing in PROD.I just confused.



Cheers,
Rajesh Gudaru