OraFAQ Forum: Performance Tuning » Slow İnsert Fast Select problem

Home » RDBMS Server » Performance Tuning » Slow İnsert Fast Select problem (Oracle 10.2.0.4 Enterprise Edition Operation sys Linux )

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

Slow İnsert Fast Select problem [message #554050]

Thu, 10 May 2012 02:05

fabi88
Messages: 112
Registered: November 2011

Senior 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

Report message to a moderator

Re: Slow İnsert Fast Select problem [message #554052 is a reply to message #554050]

Thu, 10 May 2012 02:14

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 19 14:05:18 CST 2025