Separate COUNT DISTINCT

Separate Count Distinct is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

Separate Count Distinct indicates how to handle COUNT (and other aggregation functions) when DISTINCT is present in the SQL.

Levels at Which You Can Set This

Database instance