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: TEMP tablespace size in a Data Warehouse

RE: TEMP tablespace size in a Data Warehouse

From: Gaja Krishna Vaidyanatha <gajav_at_yahoo.com>
Date: Wed, 14 Jun 2000 07:57:04 -0700 (PDT)
Message-Id: <10528.109239@fatcity.com>


Paul,

I am afraid I do not have any documentation to support this. But it is my understanding (from credible sources at Oracle) that the "true randomized estimation" is done by randomly sampling x% of a given read chunk vs. the "sequential randomized estimation" is done by sampling the first x% of a given read chunk. I can do some checking and verify this.

Regards,

Gaja.

Gaja Krishna Vaidyanatha   | 3460 West Bayshore Road,
Manager - Integration      | Palo Alto, CA 94303
& Consulting Services      | gaja_at_brio.com
Global Alliances           | (650)-565-4442
Received on Wed Jun 14 2000 - 09:57:04 CDT

Original text of this message

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