Skip to Content

Default language.

Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

ANALYZE phase

The ANALYZE phase provides information about the number of rows (cardinality) and the average row size of the data to be reorganized.

The following performance factors arise from the ANALYZE phase, and command options that you specify control these factors:

  • Amount of time that the phase requires to run
  • Accuracy of the information gathered during the phase

Related topic

Operational-considerations

The following figures show the objects that the ANALYZE phase might use (except ANALYZE HURBA, which uses no objects).


ANALYZE phase for a table space reorganization

ANALYZE_phase_table_space.png

ANALYZE phase for an index reorganization

ANALYZE_phase_index.png


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

REORG PLUS for DB2 13.1