Re: Full Table Scans

ALEX J JENTILUCCI wrote:
>
> Maybe you should define "long time".
>
> If you are getting data over a network, that could be slowing things a bit.
>
> Alex
>
> Roman Gelfand wrote in message <6t6mjq$ikd$1_at_news.monmouth.com>...
> >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)?
> >
> >

There can be many solutins.

1. TRUNCATE the table. May be your HWM is very high.
2. Analyze this table, so COST Base Optmizer can be use.
3. Make sure table has indexes

Try out. Received on Tue Sep 15 1998 - 00:06:43 CDT