Home » RDBMS Server » Performance Tuning » Slow İnsert Fast Select problem (Oracle 10.2.0.4 Enterprise Edition Operation sys Linux )
icon9.gif  Slow İnsert Fast Select problem [message #554050] Thu, 10 May 2012 02:05 Go to next message
fabi88
Messages: 7
Registered: November 2011
Junior Member
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: 58632
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.

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


Current Time: Thu Jul 31 09:02:21 CDT 2014

Total time taken to generate the page: 0.29658 seconds