Re: Full Table Scans

From: John F. Keaveney <johnkeaveney_at_targusinfo.com>
Date: Wed, 9 Sep 1998 15:48:37 -0700
Message-ID: <6t710g$mp0$1@news1-alterdial.uu.net>

What tool are you using to do the select? SQLPlus is very slow in displaying results. If you are doing the select in source code try using OCI host array fetching.

John

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)?
>
>
Received on Wed Sep 09 1998 - 17:48:37 CDT