Can I read Effective Table Reorganization Strategies on EtoBox?

Effective Table Reorganization Strategies by s.sreeraj07 is a document available to read on EtoBox.

What is Effective Table Reorganization Strategies about?

This document discusses reorganizing tables and indexes. It covers: - The goal of reorganizations is to avoid constant reorganizing and understand the root causes so corrective actions can be developed. - Reorganizing tables can be done offline by entirely rebuilding the table, or online by shrinking space or purging old data using partitioning. - Reorganizing indexes can also be done offline by entirely rebuilding indexes, or online by coalescing indexes. Metrics like deleted leaf rows, clustering fa

Author

s.sreeraj07

Language

EN