The index maintenance is one of the optimizing applications steps, and implementing sustainable index maintenance for a VLDB environment should be evaluated from several different perspectives. There are many cases for any performance hit will see on the databases, next to not having indexes or indexes that are very fragmented. Also, the issue will be multi-fold where fragmented indexes will take more space than to maintain the indexes alone impacting on all aspects of the database activities.

In this recipe, we will go through the strategy of implementing sustainable index maintenance practices for a very large database, and a database environment that must be available 24/7.