Fragment by expression and extent size

Posted in 2006

Schuran, Sven — Wed, 25 Oct 2006 09:35:38 — source: IIUG Forums & Mailing Lists

Hi, When I try to fragment a table, how to specify the extent size and next extent size. Thanks Sven

↪ replying to Schuran, Sven

Keith Simmons — Wed, 25 Oct 2006 09:59:50 — source: IIUG Forums & Mailing Lists

Sven The same way you do with a plain table: EXTENT SIZE .... NEXT SIZE .... Keith On 25/10/06, Schuran, Sven <sschuran@maske.de> wrote: > > Hi, > > When I try to fragment a table, how to specify the extent size and next > extent size. > > Thanks Sven > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to Schuran, Sven

gerd kaluzinski — Wed, 25 Oct 2006 10:03:03 — source: IIUG Forums & Mailing Lists

Hi, given extent size and next size is allocated in all fragements, so be careful that your tables do not grow by factor of fragmentation ! There ist no way to define the extent size different for some fragments. Regards, gerd > > Hi, > > When I try to fragment a table, how to specify the extent size and next > extent size. > > Thanks Sven > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _______________________________________________________________________ Viren-Scan für Ihren PC! Jetzt für jeden. Sofort, online und kostenlos. Gleich testen! http://www.pc-sicherheit.web.de/freescan/?mc=022222

↪ replying to Schuran, Sven

Thakkar, Sunil — Wed, 25 Oct 2006 13:59:25 — source: IIUG Forums & Mailing Lists

Sevn, As mentioned by others - use Extent size and next size. However, since this table is fragmented - I would use a reasonable smaller extent (minimum extent required for all the fragments) as the first extent - and the growth factor for the next extent. This way you will be sure that all the fragments has a good initial extent and only those fragments that require more space will grow based on the next extent. It also depends on the fragmentation strategy - for round robin the above does not hold true - or if you really understand your data and spread them equally then the above will be less effective but it will still hold true. Thanks, Sunil Thakkar Sr. Consultant - DBA || Office: 720.493.7012 || Cell: 720.299.6464 || Fax: 720.920.4000 || sunil.thakkar@bearingpoint.com || www.bearingpoint.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Schuran, Sven Sent: Wednesday, October 25, 2006 3:36 AM To: ids@iiug.org Subject: Fragment by expression and extent size [7670] Hi, When I try to fragment a table, how to specify the extent size and next extent size. Thanks Sven ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************** ******************* The information in this email is confidential and may be legally privileged Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system. ******************************************************************************** *******************

Glossary

fragmentation