Re: Full Table Scans

From: MotoX <rat_at_tat.a-tat.com>
Date: Thu, 10 Sep 1998 08:04:26 +0100
Message-ID: <905410972.6363.0.nnrp-01.c2de712e@news.demon.co.uk>

Or try a SELECT COUNT(*) on the table. Not much to display, and will still force a full table scan. Ditto using the FULL(table_name) hint.

Once the query is running, monitor it from both the Oracle (SGA and datafile I/O) level and the OS (disk activity and swap activity) level.

MotoX.

John F. Keaveney wrote in message <6t710g$mp0$1_at_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 Thu Sep 10 1998 - 02:04:26 CDT