Use the Locations Spatial Index Rebuild program to rebuild the spatial index on the HZ_LOCATIONS table. You should periodically rebuild the spatial index to optimize performance and accuracy for queries on the spatial data in this table.
You can schedule this program to run on a periodic basis. If possible, rebuild the index when users are not querying spatial data because the Locations Spatial Index Rebuild program interferes with user spatial operations.
Note: You cannot run the Locations Spatial Index Rebuild program if the Spatial Information for Locations Batch Update program is running.
If the HZ: Detailed Concurrent Program Output profile option is set to Yes, then you can view a detailed report about the records that the Locations Spatial Index Rebuild program processed.