Re: insert into select ... very very slow

Cross-posting is generally a bad idea..

Does the target table have indexes ; if so, drop them first.. Does the source table have the where clause ( assuming you have one) field(s) indexed; if not create them..

This should help...

( BTW, in addition to not cross-posting, providing the version and platform you are on is a very good idea...)

"bruno nogent" <bnogent_at_club-internet.fr> 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
>
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Tue Apr 23 2002 - 09:47:06 CDT