Single Table Cardinality Estimate - Teradata Database

This query is a single table SELECT that provides the cardinality of the customer table as restricted by the conditions used for the example outer join queries.

From the report returned by this query, we know how many rows should be returned by the outer join.

     SELECT  c.cust_num

     FROM sampdb.customer c

     WHERE c.district = 'K'

     AND  (c.service_type = 'ABC' 

     OR    c.service_type = 'XYZ')

     ORDER BY 1;

This query returns 18,034 rows.