Re: insert into too slow

On Jul 19, 5: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.

Well, I could make a snarky comment, but I'll just be nice and say "why don't you post the explain plan for each?"

You might read this: http://www.dbaoracle.net/readme-cdos.htm

jg

--
@home.com is bogus.
Life mocks usenet http://www.huffingtonpost.com/2007/07/17/rolling-stones-play-priva_n_56513.html