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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.