topic Re: Spatial Index need rebuild frequently? in Data Management Questions

Spatial Index need rebuild frequently?

szcszc — Sun, 11 Jul 2010 07:38:26 GMT

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?

Re: Spatial Index need rebuild frequently?

VinceAngelo — Sun, 11 Jul 2010 22:41:38 GMT

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

Re: Spatial Index need rebuild frequently?

szcszc — Mon, 12 Jul 2010 00:51:31 GMT

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.

Re: Spatial Index need rebuild frequently?

VinceAngelo — Mon, 12 Jul 2010 12:46:33 GMT

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