Querying systabstats to check for forwarded rows

You can check the forwrowcnt column in the systabstats table to see the number of forwarded rows for a table. This query checks the number of forwarded rows for all user tables (those with object IDs greater than 100):

select object_name(id) , forwrowcnt
from systabstats 
where id > 100 and (indid = 0 or indid = 1)

NoteForwarded row counts are updated in memory, and the housekeeper periodically flushes them to disk.

If you need to query the systabstats table using SQL, use sp_flushstats first to ensure that the most recent statistics are available. optdiag flushes statistics to disk before displaying values.