Re: Q:Good preformance
From: JC <jcygan_at_netxpress.com>
Date: 1997/09/20
Message-ID: <3425d1ab.2907150_at_206.67.207.6>#1/1
Date: 1997/09/20
Message-ID: <3425d1ab.2907150_at_206.67.207.6>#1/1
On 19 Sep 1997 09:58:58 GMT, "Sanlam" <joe_at_soap.com> wrote:
>you indicate how it was created and if there is contention. For inserts and
>updates you have to look at the parameters on the tables PCTUSED, PCTFREE
>as well as storage parameters for fragmentation.
I am still confused on PCTUSED, PCTFREE. Could someone give me a good plain english explanation of how these influence performance. I understand what row chaining is, and how bad it can potentially be. Is that the sole concern with these settings?
Joe Received on Sat Sep 20 1997 - 00:00:00 CEST