retrieve to what,, the screen ? a file ?
"SAS" <sumera.shaozab_at_lmco.com> wrote in message
news:a741872d.0110291348.6cd1d3b3_at_posting.google.com...
> 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;
>
> field6 is an indexed field. I should get over 1.2 million records. But
> it takes over an hour to finish retrieving all of the fields...I have
> been told that it takes 3 minutes to retrieve 3 million records. Any
> suggestions?
>
> SAS
Received on Mon Oct 29 2001 - 16:06:44 CST
