Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Full Table Scans
In article <6t6mjq$ikd$1_at_news.monmouth.com>, "Roman Gelfand" <rgelfand_at_masmid.com>
writes:
>I have a table which has roughly 5000 rows and each row averages out 84
>bytes. This is relatively small. Why is it taking a long time when I do a
>straight select on this table(no where clause)?
If you are using SQLPLus, as John has state it looks slow. The "videoing" is slow. Just put a window almost coverng theSQLPLUS session and you can watch the output fly.
Little Trick.
JasonL Received on Thu Sep 10 1998 - 18:26:23 CDT