Search notes:

Oracle SQL function: APPROX_COUNT_DISTINCT

select
   approx_count_distinct(object_name) approx_cnt,
   count(distinct(object_name))       exact_cnt
from
   dba_objects;
Github repository Oracle-Patterns, path: /SQL/select/aggregate/approx_count_distinct.sql

See also

The sort aggregate approx plan operation

Index