Spatial Index need rebuild frequently?

Question

I import some shape data into a SDE Geodatabase, including line and point. The Spatial Index is rebuilt default. I rarely add or delete a feature, and mainly modify attribute data. Later I find than  the line or point data  need rebuilding spatial index often. If I don't rebuild spatial index, reading data get more slowly.

What is the reason?

VinceAngelo · Answer

You *must* patch Oracle 10.2.0.1 if you want ArcSDE to function correctly.
10.2.0.1 is known to fail in many ways with ArcSDE and is not supported
by ESRI for use with any ESRI product. 10.2.0.3 is the minimum supported
release (you should apply the terminal CPU as well).
 
You should always apply the terminal service pack for each ESRI release
within a few months of distribution. 9.3sp1 is well over a year old, having
been superceeded by 9.3.1, 9.3.1sp1, 9.3.1sp2 and 10.0.
 
Once you apply the required patches, your ArcSDE instance is much more
likely to be functional, but you'll still need to make sure that the attribute
index statistics are current ("bouncing" the spatial index forces updates 
on the other indexes as well).
 
- V

szcszc · Answer

What database are you using?  What release and patch level?

What version of ArcSDE are you using?  What service pack and/or patches
have you applied?

What geometry storage method are you using?

Do you rebuild index statistics regularly after your attribute updates?

It's likely that spatial index reconstruction is masking your actual problem,
and is unrelated to your best solution.

- V

Database�?oracle 10.2.0.1�?don't put a patch
ArcSDE�?9.3�?don't put a patch
Geometry storage�?ST_Geometry

I don't rebuild index regularly after attribute updates, just when the indexs don't take effect, I rebuild index.

VinceAngelo · Answer

What database are you using?  What release and patch level?
 
What version of ArcSDE are you using?  What service pack and/or patches
have you applied?
 
What geometry storage method are you using?
 
Do you rebuild index statistics regularly after your attribute updates?
 
It's likely that spatial index reconstruction is masking your actual problem,
and is unrelated to your best solution.
 
- V