Home » RDBMS Server » Performance Tuning » Slow İnsert Fast Select problem (Oracle Enterprise Edition Operation sys Linux )
icon9.gif  Slow İnsert Fast Select problem [message #554050] Thu, 10 May 2012 02:05 Go to next message
Messages: 77
Registered: November 2011
Hi everyone,

I got problem,

I have a sql query which gets 60000 row in 2 second.
But when I try to insert these records to global temporary temp table(I also try just a normal table too)
It take 10 minutes...

I also tried with index/NoIndex...

samples and cost info:

insert into table_temp select * from data_table where....

insert into table select * from data_table where...

cost 1846
cost 16
cardinality :1,846

Re: Slow İnsert Fast Select problem [message #554052 is a reply to message #554050] Thu, 10 May 2012 02:14 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For any performances question, please read http://www.orafaq.com/forum/mv/msg/84315/433888/102589/#msg_433888 and post the required information.

Previous Topic: Expplain plan output
Next Topic: Help to alternate or rewrite the query (5 threads merged by bb)
Goto Forum:

Current Time: Fri Jul 28 12:27:44 CDT 2017

Total time taken to generate the page: 0.28067 seconds