data retrieval time from sql*plus command

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 - 15:48:57 CST