Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Franklin Tang asked whether tables with 20 extents hurt performance, having read that extents should stay at 8 or below. Sven Schuran said 20 was probably fine but advised checking next extent sizes, or rebuilding via unload/drop/create/load. Obnoxio The Clown suggested ALTER FRAGMENT ... INIT IN. Madison Pruet said the 8-extent limit applied only to 5.x.
Hi all,
I have a couple of tables with 20 extents, does it hurt the performance of my
database if i need to search those tables very often??? I read an article that
extent number for a table should be kept 8 or below, is that ture??? What can
i do?? drop the table with a bigger extent size?? is this the only way to do
it???
Thanks
Franklin
hi,
I think 20 extents might be ok, but please calculate what size your table
might have in a few weaks, month.
So check and change the next extent size for these tables.
If you like to put these extent together, unload table, drop table, create
table, load table with correct first and next extent sizes.
The better way is, unload whole database, drop dbspaces, create dbspaces,
create database, check next extent size of system tables, load database with
correct first and next extent sizes.
cu sven
-----Ursprüngliche Nachricht-----
Von: FRANKLIN TANG [mailto:franklin@macauslot.com]
Gesendet: Montag, 27. Januar 2003 10:31
An: ids@iiug.org
Betreff: Extent number [118]
Hi all,
I have a couple of tables with 20 extents, does it hurt the performance of my
database if i need to search those tables very often??? I read an article that
extent number for a table should be kept 8 or below, is that ture??? What can
i do?? drop the table with a bigger extent size?? is this the only way to do
it???
Thanks
Franklin
Or use
ALTER FRAGMENT ... INIT IN ...
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche
>From: "Schuran, Sven" <sschuran@maske.de>
>To: ids@iiug.org
>Subject: AW: Extent number [120] Date: Mon, 27 Jan 2003 05:39:09 -0500
>(EST)
>
>hi,
>
>I think 20 extents might be ok, but please calculate what size your table
>might have in a few weaks, month.
>So check and change the next extent size for these tables.
>If you like to put these extent together, unload table, drop table, create
>table, load table with correct first and next extent sizes.
>
>The better way is, unload whole database, drop dbspaces, create dbspaces,
>create database, check next extent size of system tables, load database
>with correct first and next extent sizes.
>
>cu sven
>
>-----Ursprüngliche Nachricht-----
>Von: FRANKLIN TANG [mailto:franklin@macauslot.com]
>Gesendet: Montag, 27. Januar 2003 10:31
>An: ids@iiug.org
>Betreff: Extent number [118]
>
>
>Hi all,
> I have a couple of tables with 20 extents, does it hurt the
>performance of my database if i need to search those tables very often??? I
>read an article that extent number for a table should be kept 8 or below,
>is that ture??? What can i do?? drop the table with a bigger extent size??
>is this the only way to do it???
>
>
>Thanks
>
>Franklin
_________________________________________________________________
Chat online in real time with MSN Messenger http://messenger.msn.co.uk
The 8 extent issue is with 5.x only.
M.P.
"FRANKLIN TANG"
<franklin@macausl To: ids@iiug.org
ot.com> cc:
Sent by: Subject: Extent number [118]
forum.subscriber@
iiug.org
01/27/2003 03:31
AM
Hi all,
I have a couple of tables with 20 extents, does it hurt the performance
of my database if i need to search those tables very often??? I read an
article that extent number for a table should be kept 8 or below, is that
ture??? What can i do?? drop the table with a bigger extent size?? is this
the only way to do it???
Thanks
Franklin
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.