Re: determining extent sizes
From: Michael Abbey <msabbey_at_magi.com>
Date: 1996/01/18
Message-ID: <4dkfm2$7c2_at_news.magi.com>#1/1
Date: 1996/01/18
Message-ID: <4dkfm2$7c2_at_news.magi.com>#1/1
My feeling is to always allocate one extent large enough for the whole table.
Michael
chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:
>I'm curious as to what other DBAs do when creating new tables. Is it
>better to:
>1) estimate actual table sizes and create the initial extent to be
>that size,
>or
>2) make all extents the same size so it's easier for the RDBMS to
>reuse free'd up extents?
>--
>Chuck Hamilton
>chuckh_at_ix.netcom.com
>Never share a foxhole with anyone braver than yourself!
Received on Thu Jan 18 1996 - 00:00:00 CET