Re: insert into too slow

From: <fitzjarrell_at_cox.net>
Date: Thu, 19 Jul 2007 11:47:55 -0700
Message-ID: <1184870875.095982.204190@k79g2000hse.googlegroups.com>

On Jul 19, 7:04 am, valigula <valig..._at_gmail.com> wrote:
> 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.

ONE thread is sufficient per topic; two is overkill and likely to get you ignored.

David Fitzjarrell Received on Thu Jul 19 2007 - 13:47:55 CDT