Ways to get row count in sybase
Reference : Sybase ISUG FAQs

Getting Row Counts in User Tables Adaptive Server Enterprise keeps row counts of tables in the first OAM page for the object. The system table sybstabstats, introduced in Adaptive Server 11.9.1, also keeps the row count for all user tables. Depending on which server version you are using, there are several ways to obtain the row count for any table:

* Querying the table (all versions).
* Using sp_spaceused (SQL Server 4.8 and higher).
* Using the optdiag utility (11.9.2 and higher).

QUERYING THE TABLE (all versions)

In all versions of Adaptive Server and Sybase SQL Server, you can get row counts for any table by querying the table directly. The syntax is:

select count(1) from table_name



Using sp_spaceused (SQL Server 4.8 and higher)

To get a row count indirectly, without querying the table, use the sp_spaceused system stored...