|
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 ?
What is better approach to divide
indexs
A ) should I
devide them that based on size ( big, small ) and create seperate tablespaces
with different values for extent size .
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
|
- Re: LMT Migration AK
- Re: LMT Migration Gabriel Aragon
- Re: LMT Migration Ron Rogers
- Re: LMT Migration Tanel Poder
- RE: LMT Migration DENNIS WILLIAMS
