Re: extended statistics n-distinct on multiple columns not used when join two tables

Hi út 13. 6. 2023 v 11:21 odesílatel James Pang (chaolpan) napsal: > Hi, > > When join two table on multiple columns equaljoin, rows estimation > always use selectivity = multiplied by distinct multiple individual > columns, possible to use extended n-distinct statistics on multiple > colu

extended statistics n-distinct on multiple columns not used when join two tables

Hi, When join two table on multiple columns equaljoin, rows estimation always use selectivity = multiplied by distinct multiple individual columns, possible to use extended n-distinct statistics on multiple columns? PG v14.8-1, attached please check test case with details. Thanks, Jam