Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
Windows and .NET
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 17, 2013 12:29 PM by
Spatial Index- Rtree Indexing
Jan 17, 2013 6:38 AM
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
This content has been marked as final.
Show 1 reply
Re: Spatial Index- Rtree Indexing
Jan 17, 2013 12:29 PM
in response to
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. :)