Re: Finding total Rows without count() ?

> SQL> analyze table parameter estimate statistics ;
>
> Table analyzed.
>
> Elapsed: 00:00:10.27
>
> So the quickest way seems to be the analyze table,
> Shortly followed by select(1).
>

You need to also add the time it takes to select the rowcount from the view as well as show that the number returned is close.

• Paul