RE: number of rows
Along with 'oncheck -pt database:table', You can also use the following:
select * from sysmaster:sysptprof p, sysmaster:sysptnhdr h
where p.partnum=h.partnum
(which is equivalent to oncheck -pt)
This method is better, then 'select from systables'
because it doesn't require 'update statistics'; similar
to 'oncheck', it takes data directly from 'tablespace tablespace'
------------------------------------------
Alexey Sonkin
Senior Database Administrator
> -----Original Message-----
> From: Jorge Valenzuela [mailto:jorgev@uabc.mx]
> Sent: Monday, November 10, 2003 9:17 PM
> To: informix-list@iiug.org
> Subject: number of rows
>
>
> Hi all:
>
> Can anybody tell me how can I know how many rows, indexes and fields there
> are in every table on my database ?
>
> Thanks in advance.
>
>
> hpux 11.0
> ids 7.3
>
>
> sending to informix-list
sending to informix-list