Re: Does the number of extents affect the performance?

From: Sam Brown <brown_at_technovations.com>
Date: 1997/09/12
Message-ID: <3418D099.1AA4@technovations.com>#1/1

Thomas Kyte wrote:

> >On Tue, 09 Sep 1997 22:25:37 -0700, Mohamed El-Mallah <mie_at_mainruis.sannet.gov>
> >wrote:

Good arguments, counter-arguments, and good math deleted...

But hasn't Mohamed demonstrated the pathological worst case ? Is this typical ?

We still want to answer the original question of "As far as performance goes, do extents matter ?". And the answer seems to be "It -almost- never is an issue." Shouldn't we ?

-- 
Sam Brown, Technovations International Inc.
http://www.technovations.com
Having problems with performance ? Check out our Capacity Planning and
Analysis Products.

Received on Fri Sep 12 1997 - 00:00:00 CDT