quer Performance issue

[PAVB]

As i mentioned earlier both the PROD and DEV having the same rows.
But in pROD execution plan it was showing more rows.
Here i am just confused.

Are you fully qualifying table_names in your query?

Please run and post:

select  owner,
        table_name,
        num_rows,
        last_analyzed
from    sys.dba_tables
where   table_name in('CONTRACT_TRANS');