Re: CTAS question
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: adar666@xxxxxxxxxxxx
- Date: Wed, 31 May 2006 12:20:33 +0200
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@xxxxxxxxxxxx> 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
- References:
- RE: CTAS question
- From: Allen, Brandon
- Re: CTAS question
- From: Yechiel Adar
Other related posts:
- » CTAS question
- » RE: CTAS question
- » Re: CTAS question
- » Re: CTAS question
- » Re: CTAS question
- » RE: CTAS question
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
- RE: CTAS question
- From: Allen, Brandon
- Re: CTAS question
- From: Yechiel Adar