Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Know of any downloadable histogram viewers for Oracle?

RE: Know of any downloadable histogram viewers for Oracle?

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Fri, 4 Aug 2006 21:32:34 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF615111@MSXVS04.trivadis.com>


Charles

> Reading the abase website, Cassandra sounds like an amazing tool.
> Although, a few more features than we are interested in, their
philosophy
> sounds... sound. However, I am skeptical of their claim:
>
> "Generating statistics for very large and heavily used tables with
> Oracle's analyze command can take anything up to several hours
depending
> on the size and usage of the table being analyzed. With Cassandra,
those
> statistics can be calculated within minutes."
>
> How can you do that without sampling? And once you start sampling, you
> introduce the possibility of error.

On large tables there's a very easy way to do it without sampling: parallelization.

Cheers,
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 04 2006 - 14:32:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US