Re: insert into too slow

On Thu, 19 Jul 2007 05:04:15 -0700, valigula <valigula_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.

You have a lot of indexes on the table? That would be my guess, initially.

• Rich