Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: data retrieval time from sql*plus command

Re: data retrieval time from sql*plus command

From: Paul Quenneville <paulq_at_home.com>
Date: Mon, 29 Oct 2001 22:06:44 GMT
Message-ID: <UpkD7.113751$5h5.46026501@news3.rdc2.on.home.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US