Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> insert into too slow

insert into too slow

From: valigula <valigula_at_gmail.com>
Date: Thu, 19 Jul 2007 05:04:15 -0700
Message-ID: <1184846655.754365.92050@r34g2000hsd.googlegroups.com>


Hi all

oracle 9i
When i execute a "insert into select" it takes ages. It took yesterday over 3 hours with no results, but when i execute just the select it takes 30 sec. has anyone has a similar problem.

I did not post the query since cross several tables and use a few cases withing the select. Received on Thu Jul 19 2007 - 07:04:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US