Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 7819 invoked from network); 22 Jul 2007 16:03:24 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 22 Jul 2007 16:03:24 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3908C71681F; Sun, 22 Jul 2007 17:01:11 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20138-01-9; Sun, 22 Jul 2007 17:01:11 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 264237160EA; Sun, 22 Jul 2007 17:01:10 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 22 Jul 2007 16:19:31 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8B43F716CE8 for ; Sun, 22 Jul 2007 16:19:31 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30854-02 for ; Sun, 22 Jul 2007 16:19:31 -0400 (EDT) Received: from mailx2.trivadis.com (gromit.trivadis.com [212.249.206.2]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0A535716B73 for ; Sun, 22 Jul 2007 16:19:29 -0400 (EDT) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Hybrid histograms in 11g ? Date: Sun, 22 Jul 2007 22:21:34 +0200 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Hybrid histograms in 11g ? From: "Christian Antognini" To: "Milen Kulev" Cc: X-archive-position: 51160 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Christian.Antognini@trivadis.com Precedence: normal Reply-to: Christian.Antognini@trivadis.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain 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