Re: POL:Open big table needs >6 hours! Help!

From: Andreas Seebeck <A.Seebeck_at_t-online.de>
Date: 1998/03/24
Message-ID: <6f8ddv$voq$1@news00.btx.dtag.de>#1/1

>unless there aren't any order by - or where- clauses in your statement there should be no difference in time to get the first few records. To reallly get all records displaid takes a long time, since
>SQL*Plus is as fast as a snail when it comes to display records.

So, what's wrong? It really takes a long time before sql+, Navigator or any other tool shows the first records. A select * from x on a 10000 record table makes a pause of almost a minute, on 300000 it doesn't seem to come again.

If you say that isn't normal behaviour (in Personal Oracle lite), what could be the problem?

Regards,

Andreas Received on Tue Mar 24 1998 - 00:00:00 CST