On Apr 16, 11:24 am, DA Morgan <damor..._at_psoug.org> wrote:
> deva..._at_gmail.com wrote:
> > As to the assumption I'm making that a single data block contains only
> > the data for a single customer...
> > If I am using a single table b*tree cluster and I've configured it to
> > only allow the records for a single customer to be stored within a
> > single data block, that data block will only contain records
> > associated with a single customer.
>
> I'd like to be the guy who sells your storage. <g>
>
> You are talking about the possibility of one record per block.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Given that each record is ~43 bytes and each customer can have ~1000
records we get ~42 kB of data per customer. At 8kB per block, minus
overhead and pctfree settings... I'm looking at around 180 - 200
records per block. Independent if it is in a cluster or and
traditional heap table. Clustering merely allows those 180 -200
records to all be of the same cluster key (customer). Resulting in
5-6 blocks containing all 1000 records for a single customer.
Received on Mon Apr 16 2007 - 12:29:08 CDT
