OraFAQ Forum: Performance Tuning » Execution time differences between Devl and Test

Home » RDBMS Server » Performance Tuning » Execution time differences between Devl and Test (Oracle 10g/Windows2000)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Execution time differences between Devl and Test [message #302693]

Tue, 26 February 2008 11:34

gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA

Senior Member

Hi,
I'm running this below query in Devl and Test environments. Number of records, execution plan are same and statistics are upto date. But in Test, query takes more time to execute than Devl.

SELECT /* my column list */ 1
        FROM    table1 a, --18164 rows
                table2 b, --667689
                table3 c  --2144800 
        WHERE   a.client_id     = '6334'
        AND     a.portfolio_id  = c.subacct_id
        AND     c.sec_id = b.sec_id
        AND     c.tran_cd     IN ('A','D')
        AND     b.asset_typ     = 'A1'
        AND     c.trn_tran_type = 'AT';

What could be the possible reasons?

//Thangam

[Updated on: Tue, 26 February 2008 11:36]

Report message to a moderator