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
 

Reply via email to