RE: Hybrid histograms in 11g ?

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: "Milen Kulev" <makulev@xxxxxxx>
  • Date: Sun, 22 Jul 2007 22:21:34 +0200

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

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


Other related posts: