Home » SQL & PL/SQL » SQL & PL/SQL » Insert into select clause is taking long time than the select [merged]
Insert into select clause is taking long time than the select [merged] [message #396759] Wed, 08 April 2009 00:12 Go to next message
kg.dilip@gmail.com
Messages: 1
Registered: April 2009
Junior Member
No Message Body
Re: Insert into select clause is taking long time than the select [message #396760 is a reply to message #396759] Wed, 08 April 2009 00:15 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

ANSWER IS 42
Re: Insert into select clause is taking long time than the select [message #396769 is a reply to message #396759] Wed, 08 April 2009 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Insert into select clause is taking long time than the select

Why wouldn't it?

Regards
Michel
Re: insert into select clause is taking long time than the select [message #396783 is a reply to message #396759] Wed, 08 April 2009 01:12 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
HUH?
Re: insert into select clause is taking long time than the select [message #396789 is a reply to message #396759] Wed, 08 April 2009 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can post it hundred times, the answer is the same:
Michel Cadot wrote on Wed, 08 April 2009 07:48
Quote:
Insert into select clause is taking long time than the select

Why wouldn't it be?

Regards
Michel

[Updated on: Wed, 08 April 2009 02:00]

Report message to a moderator

Re: insert into select clause is taking long time than the select [message #396801 is a reply to message #396789] Wed, 08 April 2009 01:39 Go to previous message
swayamji
Messages: 15
Registered: March 2009
Location: Washington DC
Junior Member
Hi,
insert query take time more then select statement.
can you check in your database any locks on these 3 table?
regards
Swayamprakash.Chiluveru
Previous Topic: How to write down regular expression for this
Next Topic: Subquery in Order by Clause
Goto Forum:
  


Current Time: Sun Dec 11 03:58:37 CST 2016

Total time taken to generate the page: 0.10638 seconds