Amazon Redshift provides three methods for retrieving row counts in tables and views: using the COUNT function, system statistics, and combining multiple methods. The COUNT function allows an exact count of rows, while system statistics provide approximate counts but are updated automatically. Combining both methods ensures accuracy in tracking row counts over time.