RE: Hybrid histograms in 11g ?

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Sun, 22 Jul 2007 22:21:34 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAFBBE0D4@MSXVS04.trivadis.com>

Hi Milen

> I was just interested in the Oracle implementation

I didn't investigate the internals right now... But simply put they create a virtual column (which is another nice 11g feature) that combines two or more columns together. Then the histogram as well as all other column statistics are created as usually. Hence the 254-buckets limitation.

Cheers,
Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jul 22 2007 - 15:21:34 CDT