Hello,
I have a very strange issue occuring with SDE. I have a statewide roads feature class (using ST_GEOMETRY) with about 147,000 records and one level of spatial index that redraws very quickly when I first buillt it, or if I drop it and rebuild it using ArcCatalog. However, after only a few hours, if I start ArcMap and add this feature class to the dataframe it will typically take about between 3 and 8 seconds to redraw, regardless of scale. If I execute the command to rebuild the spatial index using sdetable -o rebuild_index, the dataframe will then refresh instantly or nearly instantly. However, if I leave this session of ArcMap open and start a new session adding the same dataset to the map, the drawing speed is slow in the new session, but fast in the original session. If I reexecute the rebuild index command now, both sessions will redraw instantly. Now, if I close both sessions, and start a new one the performance is slow again.
I have about 20 versions that are all children of Default, and I see about 100 edits per day. I run a batch reconcile process each night followed by a compress, a rebuild on all the indexes, and an analyze on this featureclass. Also, I 'm running SDE 9.3.1 on Oracle 10.2.0.3. I'm connecting through the SDE, although I have confirmed that the same problem occurs using direct-connect.
Any help would be greatly appreciated as this one has me stumped.
Thanks,
David
