Re: Opinions on multiple extents on tables/indexes

From: Wolfgang Breitling <breitliw_at_netcom.ca>
Date: 1997/05/22
Message-ID: <5m19n2$5n0@dfw-ixnews12.ix.netcom.com>#1/1

In article <MPG.dea434573b770cb989689_at_snews.zippo.com>, fran_at_rbsbooks.com (Frances Edelstein) wrote:
>In article <5knbrj$cqa$2_at_news2.alpha.net>, scott.overby_at_sdsdata.com
>says...
>> What is the conventional wisdom on having multiple extents on tables/indexes
>> and the effect on performance?

I recommend that you get and read Cary Milsap's (Oracle) whitepaper "Oracle 7 Server Space Management". He spends a good portion of Chapter 7 dispelling the myths surrounding multiple extents and performance. In a nutshell, If planned correctly, multiple extents do not hurt performance. Received on Thu May 22 1997 - 00:00:00 CDT