Re: Need a Fast Row Count

From: Alan <alanshein_at_erols.spambuster.com>
Date: 2000/03/24
Message-ID: <8bgcnm$bdf$1@bob.news.rcn.net>#1/1

select count(rownum) from table

Gary Brumfield wrote in message <38DA4117.74046877_at_lmco.com>...
>Is there any other way than "select count(*) from <table>" to return the
>number of rows in an Oracle table? This takes forever to run (>3
>minutes) on a table that has over 3 million rows. I guess it has to do
>a full table scan to determine the correct number of rows and in a read
>consistent manner. It would be OK even if we got a count that was
>fairly close.
>
>Any Ideas or Insight?
>
Received on Fri Mar 24 2000 - 00:00:00 CST