SQL COUNT DISTINCT has been slow. It is, in essence, a grouping operation, which keeps traversed grouping field values for later comparisons. When the result set is too large, the data needs to be ...

Crosstab with zero counts and counts of distinct values proc freq and sql %let pgm=utl-crosstab-with-zero-counts-and-counts-of-distinct-values-wpe_r_sql; ...

The series of blog posts I wrote last year on semantic model memory usage, in particular this post on the query memory limit and the “This query uses more memory ...