I have a spatial table. i have created index. If I keep on inserting data in my table do i need to rebuilt the index or is the data automatically indexed?
Edited by: 951616 on Jan 16, 2013 10:37 PM
Far as I know, R-Tree indexes are updated automatically. There's a section in the Oracle Spatial user guide that mentions how to defer it in order to make bulk inserts faster, so I'm pretty confident that's right. :)