Re: insert into select ... very very slow

bruno nogent wrote:
>
> I'm testing to insert into a table the datas of a select statement
>
> insert into mytable select ......
>
> but it's very very slow
> The table to copy is : 200 lines and 50 columns
>
> Where is the problem ?
>
> Thanks

Is the select on its own quick?

If yes, then look at

1. the size of your redo logs
2. the number of indexes on your table
3. any locking problems on the table

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."