On 29 Oct 2001 13:48:57 -0800, SAS
<sumera.shaozab_at_lmco.com> a écrit:
>Hi,
>
>Does it normally take an hour to retrieve 1.2 million records from
>sqlplus command line?
>
>This is what I am doing;
>
>select field1,field2,field3,field4,field5 from table1 where field6 =
>1;
If you want to 'spool' it, and you're through a telnet or net8 connection,
you'd better run it in a .sql file, with a 'set termout off' in order to
save off some network traffic.
--
Damien
Received on Mon Oct 29 2001 - 16:35:10 CST
