English

FAQ: Should the ArcSDE for Oracle 8.1.1 Spatial Index table be analyzed?

Question

Should the ArcSDE for Oracle 8.1.1 Spatial Index table be analyzed?

Answer

Yes. As of ArcSDE for Oracle 8.1.1, ESRI has started analyzing the Spatial Index table. In previous releases of ArcSDE, it was found that analyzing the Spatial Index table could be detrimental to the performance of a spatial query. However, through testing and customer notification, ESRI has determined that the Oracle Cost Based Optimizer has evolved, and it is now important that the Spatial Index table always be analyzed.