Re: CTAS question

CTAS is optimized, sort of like INSERT /*+ APPEND */ - plus the already mentioned network lag between your client and the server.

Stefan

On 5/31/06, Yechiel Adar <adar666_at_inter.net.il> wrote:
>
> How much time it take to:
> Select * from result_table;
>
> This will give you an indication how much time it take to move the data
> to the client.
>
> Adar Yechiel
> Rechovot, Israel
>
>
>
> Allen, Brandon wrote:
>
> >Maybe it's taking 7 minutes to return the data to your client over the
> >network if it's a lot of data and/or you have a slow network connection.
> >How long does it take if you just spool the output to a file on the
> >server (set term off)?
> >
> >Regards,
> >Brandon Allen
> >
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l