Re: Number of Extents on SYS tables

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 18 Nov 1999 18:59:38 +0800
Message-ID: <3833DC1A.6306@yahoo.com>

Chuck wrote:
>
> Is it healthy to have tables owned by SYS with upwards of 75 extents?
> I have a handfull (like 15 - 20) tables with 75 or more extents.
>
> Thanks,a
> Chuck

Assuming they are legitimately SYS tables, then it is not a drastic problem since SYS uses the rule optimiser but you can avoid these problems in future by taking an (informed) look at SQL.BSQ before creating your database.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Nov 18 1999 - 04:59:38 CST