Message-Id: <25988.338909@fatcity.com> From: "AK" Date: Tue, 22 Jul 2003 08:53:45 -0700 Subject: LMT Migration This is a multi-part message in MIME format. ------=_NextPart_000_0348_01C3502E.C2640B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable At present we have one tablespace containign all indexes . Some indexes = are big in size some are small . Currently tablespace is dict managed. = This tablespace currently highly fragmented . Now I am planning to move the indexes to a LMT. Now how to decide what = should be the extent size for uniform extents ?=20 What is better approach to divide indexs=20 A ) should I devide them that based on size ( big, small ) and create = seperate tablespaces with different values for extent size .=20 b) or seperate them based on modules sooo that accounting and = manufactring related indexes goes to different tablespace. Does number of extents is a performance issue in LMT as well ? Any = experience ? Thanks, -ak ------=_NextPart_000_0348_01C3502E.C2640B80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

At present we have one tablespace = containign all=20 indexes . Some indexes are big in size some are small . = Currently=20 tablespace is dict managed. This tablespace currently highly fragmented=20 .

Now I am planning to move the indexes = to a LMT. Now=20 how to decide what should be the extent size for uniform extents ? =

What is better approach to divide=20 indexs

A ) should I=20 devide them that based on size ( big, small ) and create seperate = tablespaces=20 with different values for extent size .

b) or seperate = them based on=20 modules sooo that accounting and manufactring related indexes goes to = different=20 tablespace.

Does number of extents is a performance = issue in=20 LMT as well ? Any experience ?

Thanks,

-ak