Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select count(*)
: I have a table of 10 million rows with 20 columns
select count (*) is usally done through full table scan. Forcing some suitable index is possible to do this operation through fast full scan of index. Indexes are usually smaller in size so counting will be faster. See dba_segments view sizes of objects.
Starous Received on Fri Jul 28 2000 - 00:00:00 CDT