Rebuilding Multiple Indexes

Sometimes DBAs may need to rebuild indexes. For example, they might simply want to relocate an index to a different tablespace or rebuild it with different storage parameters. Other times, DBAs need to locate and then rebuild those indexes that have become unusable (that is, corrupted), whose B-trees have become unbalanced, or whose storage parameters were inappropriately sized for their growth needs. Whatever the reasons, TOAD provides a simple yet potent screen for making index rebuilds of any type a snap. Plus this screen can be run from the command line with e-mail notification capabilities. So TOAD can now fully automate your entire index rebuild candidate detection and code execution process via the Windows ...

Get TOAD® Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.