Re: insert into select ... very very slow
Date: Tue, 23 Apr 2002 22:21:46 -0700
Message-ID: <O9HUT606BHA.1188_at_cpimsnntpa03>
you're asking a very generalized question so it is difficult to give a specific answer. however, might i suggest you first use the explain plan to analyze your select statement.
there can be many factors that effect performance of the statement: no indexes, incorrect indexes, too many indexes, fragmented data files, database architecture, locks, etc, etc.
"bruno nogent" <bnogent_at_club-internet.fr> wrote in message
news:aa3jlq$uij$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
>
>
>
>
Received on Wed Apr 24 2002 - 07:21:46 CEST