Re: insert into select ... very very slow

"bruno nogent" <bnogent_at_club-internet.fr> сообщил/сообщила в новостях следующее: news:aa3jfc$t6n$1_at_s1.read.news.oleane.net...
> 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

You better try to use 'Create table mytable as select...'

May the Force be with you!
Jedi

jedi_at_entecheco.com Received on Tue Apr 23 2002 - 07:40:39 CDT