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: Full Table Scans

Re: Full Table Scans

From: <jal_at_esc188.expansion.com>
Date: 10 Sep 1998 23:26:23 GMT
Message-ID: <6t9n6v$12a$1@holly.prod.itd.earthlink.net>


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

Original text of this message

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