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

On 24 Mar 1998 08:53:12 GMT, A.Seebeck_at_t-online.de (Andreas Seebeck) wrote: Hi,

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.

>Hi,
>now I managed it to fill a table with sqlloader with 300000 records,
>and I'm not able to open it anymore, because the bigger the table is
>the more time needs to open(show it in a grid) it. Am I doing
>something wrong? Or is that a normal behaviour? I use the oracle
>explorer to open it. In sql+ almost the same happens: the bigger the
>amount of data to return is, the more time is needed before the editor
>begins to show the resulting records. A select * in the big table and
>the pc hangs for more than 6 hours.
>
>Thanks in advance for any help,
>
>Andreas

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de