Re: Total rows in table

Kathinka Diehl wrote:

> Thomas Kyte <tkyte_at_us.oracle.com> schrieb:
> >
> > counting the rows with count() is the way to get the row count if you
> really
> > really need it.
>
> How about "select max(rownum) from TABLE"?

SQL> select max( rownum ) from emp;

MAX(ROWNUM)

     229376

Execution Plan

   0 SELECT STATEMENT Optimizer=CHOOSE    1 0 SORT (AGGREGATE)

   2    1     COUNT
   3    2       TABLE ACCESS (FULL) OF 'EMP'

Cheers,

    Fred

>
>
> Regards
> Kathinka

--

+-------------------------------------+----------------------------+
| Fred Petillot                       |     fpetillo_at_fr.oracle.com |
| Oracle France - Support Technique   |            +33 1 4762 8201 |
| 65, rue des Trois Fontanot          |            +33 6 8089 5135 |
| 92732 Nanterre Cedex                |                            |
+-------------------------------------+----------------------------+