Home » RDBMS Server » Performance Tuning » Query performance related (oracle )
Query performance related [message #531773] Thu, 17 November 2011 10:54 Go to next message
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.
Re: Query performance related [message #531775 is a reply to message #531773] Thu, 17 November 2011 11:00 Go to previous messageGo to next message
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:
Re: Query performance related [message #531777 is a reply to message #531773] Thu, 17 November 2011 11:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what will be the reason


You do not do it properly.

Regards
Michel
Re: Query performance related [message #532316 is a reply to message #531773] Mon, 21 November 2011 23:32 Go to previous messageGo to next message
ramnath1989
Messages: 48
Registered: November 2011
Location: india
Member
U have to read Query Optimization
Sad
Re: Query performance related [message #536382 is a reply to message #532316] Tue, 20 December 2011 10:42 Go to previous message
hemant_khandare
Messages: 72
Registered: November 2011
Member
thanks
Previous Topic: buffer busy wait
Next Topic: Query on Explain Plan Steps
Goto Forum:
  


Current Time: Thu Mar 28 03:57:13 CDT 2024