Re: Total rows in table

From: <rock_cogar_at_my-deja.com>
Date: Mon, 03 Jan 2000 14:07:57 GMT
Message-ID: <84qafl$7at$1@nnrp1.deja.com>

First you need to run ANALYZE.

Example:

analyze table myschema.mytable compute statistics;

Rock.

In article <84q0rs$1at$1_at_nnrp1.deja.com>, Alex Vinokur <alexander.vinokur_at_telrad.co.il> wrote:
> Using the following SQL command
> SELECT count (*) FROM MY_TABLE;
> we can get number of rows in MY_TABLE.
>
> Question. Is there another way to get this number?
> I tried to use the SQL command :
> SELECT NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME='MY_TABLE';
> However, what I obtained is not number of rows in MY_TABLE.
>
> Thanks in advance,
> Alex
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 03 2000 - 08:07:57 CST