Re: How many extents is too many?

I start taking a serious look after 10...

Mr. Richardjr F. Sullivan (LGHX88A_at_prodigy.com) wrote:
: I've had hundreds of extents, however they were for the same table in a
: tablespace of their own, making the extents contiguous anyway. Extents
: seem to bother performance only when they are scattered about in a
: tablespace amongst many tables/indexes and either full table scans are
: performed or there is already contention for that disk. Subsequent
: reorgs should occur on a regular basis anyway for PM purposes......
: Just my $.03 (inflation....!)

--
    ..uu.           Randy DeWoolfson          ----------------------
  .?$" '?i     .                              I  randyd_at_cais.com   I
 .T^M  ._at_"    d9    .    .f   ,.un.  t     ,  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``Y# `M   _at_"  I brandall_at_erols.com I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I     ,\//.      X   I
    &  'M ,P    `E  M   "$  Mux~      n!`     I     |o o|          I
   dk   `h"       ' j     " y"       *~       I=oOO==(_)==Ooo======I