Re: multi-column indexes, statistics and selectivity

From: joel garry <joel-garry_at_home.com>
Date: Fri, 4 Dec 2009 09:29:58 -0800 (PST)
Message-ID: <ebdeffc1-8016-40b4-aab2-af33f89eb9e3_at_x25g2000prf.googlegroups.com>

On Dec 4, 9:09 am, bugbear <bugbear_at_trim_papermule.co.uk_trim> wrote:
> 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

Check this out:
http://richardfoote.wordpress.com/2008/09/16/index-monitoring-and-index-statistics-the-great-gig-in-the-sky/#comments

jg

--
_at_home.com is bogus.
"...Network hardware includes Dell servers, Dell workstations, IBM
RS6000 and P570 RISK based systems, Cisco routers, and HP ProCurve
switch’s.
MINIMUM REQUIREMENTS
Qualified candidates must have a Bachelor’s degree in Computer Science
or a related degree with 4-6 years programming experience with HTML/
CGI/Java, ASP.Net and an understanding of internet working and
knowledge of applications available on the WEB, Business Objects XIR2,
Crystal Reports XIR2, VB6 Programming Language, Visual Basic and
Studio, in an Oracle/AIX/2003 environment, or..." - metrolink job ad.

Received on Fri Dec 04 2009 - 11:29:58 CST