Re: multi-column indexes, statistics and selectivity
From: bugbear <bugbear_at_trim_papermule.co.uk_trim>
Date: Fri, 04 Dec 2009 17:09:39 +0000
Message-ID: <7IednZga16jO34TWnZ2dnUVZ8qli4p2d_at_brightview.co.uk>
bugbear wrote:
> Can anyone tell me (or point me at information) about
> how statistics are generated/used for multi-column indexes?
>
Date: Fri, 04 Dec 2009 17:09:39 +0000
Message-ID: <7IednZga16jO34TWnZ2dnUVZ8qli4p2d_at_brightview.co.uk>
bugbear wrote:
> Can anyone tell me (or point me at information) about
> how statistics are generated/used for multi-column indexes?
>
Apologies: I should have said "in 10g".
I've also found a reference to a new feature in 11g; "Multi-column histograms"
If this is new in 11g it has "unfortunate" implications for our running on 10g...
BugBear Received on Fri Dec 04 2009 - 11:09:39 CST