Business Intelligence Tutorial

Reorganizing a table

Reorganizing a table rearranges it in physical storage, eliminating fragmentation and making sure that the table is stored efficiently in the database. You can also use reorganization to control the order in which the rows of a table are stored, usually according to an index.

To reorganize the LOOKUP_MARKET table:

  1. From the DB2 Control Center, right-click on the LOOKUP_MARKET table and click Reorganize.

    The Reorganize Table window opens.

  2. In the Using system temporary table space field, specify the name of the table space where the table being reorganized can be temporarily stored. If you do not specify a table space, the temporary copy of the table is stored in the same table space where the table currently resides.
  3. In the Using index field, specify the index to use to reorganize the table rows. If you do not specify an index, the table rows are reorganized without regard to order.
  4. Click Reorganize Now to reorganize the table immediately. Click Schedule to schedule the reorganization for a specific date and time.


    The GEOGRAPHIES SELECT statement on the SQL Statement page.


[ Top of Page | Previous Page | Next Page | Table of Contents ]