Select to view content in your preferred language

Geodatabase rebuild indexes

12-04-2018 07:17 AM
New Contributor III


this is alberto Ordonez from Esri Spain. An important Telco customer is asking about a particular question related to rebuild indexes on an Oracle Geodatabase (Oracle10g and ArcSDE 9.3.1 Sp2). In order to rebuild indexes for all schema owners and sde, they are asking if it possible to use Alter index rebuild online instead of Alter index rebuild because first method is less restrictive and faster.

Thank you.

0 Kudos
3 Replies
Occasional Contributor III

Hi Alberto,

We'd probably recommend they stick to the non-online option here. the ONLINE keyword rebuilds the indexes while still allowing queries against them. It also means there is some cleanup needed after the process is done to capture anything that was done while the indexes were being rebuilt.

Our documentation uses the non-online option so that is what I'd recommend to your user.

FAQ: What indexes in Oracle should be frequently rebuilt to maintain optimal performance with versio... 

ALTER INDEX REBUILD  (See the Usage Notes section, second paragraph on what ONLINE does)


New Contributor III

Thanks Jonathan.

0 Kudos
Esri Regular Contributor

Also take a look here.

Oracle index rebuild online