On 9/11/2024 03:32, Ed Sabol wrote:
> CREATE STATISTICS tablename_stats_rt_nd (ndistinct) ON relation, type FROM tablename;
The only one thing I want to note. It is enough to execute:
CREATE STATISTICS tablename_stats (mcv,ndistinct,dependencies)
ON relation, type FROM tablename;
And all the statistics will be build over any possible combination of
(relation, type). So, you don't need to call CREATE STATISTICS more than
once.
--
regards, Andrei Lepikhov
