I know the idea has come up a few times to do cross-column statistics to
improve plans when the data distributions are dependent. I found a
couple references in the archives:


We can already keep stats for a functional index. Is there a reason we
can't keep stats for a multi-column index?

Out of the two situations outlined by Jim Nasby here:


It would not help with joins, but it would help with columns that are
referred to as a group (e.g. a=1 AND b<20).

        Jeff Davis

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to