OraFAQ Forum: Performance Tuning » Query performance related

Home » RDBMS Server » Performance Tuning » Query performance related (oracle )

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

Query performance related [message #531773]

Thu, 17 November 2011 10:54

hemant_khandare
Messages: 72
Registered: November 2011

Member

i hv two table
1>tab1
2>tab2

if i update any values from tab1 to tab2 its takes 4 seconds to update 1.5 lakhs records.
bt if i do revers of above case then its takes 29 hrs ...

what will be the reason could any 1 help me out.

Report message to a moderator

Re: Query performance related [message #531775 is a reply to message #531773]

Thu, 17 November 2011 11:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Since NOBODY can optimize SQL just by looking at it, we need a few more details.
http://www.orafaq.com/forum/m/433888/136107/#msg_433888
Please refer to URL above & be sure to provide the details requested:

Report message to a moderator