SAS wrote:
>
> 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
Have you done any performance tuning (using tkprof and explain plan)?
Are you connecting over a network? What are you disk statistics? What
other kind of work is going on within the instance?
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Mon Oct 29 2001 - 16:15:58 CST
