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
