Changing table organization

You can analyze tables to change the organization to column-organized for improving performance.

Procedure

To change table organization:

  1. Create a tuning task on a workload, with Table organization tuning option selected.
  2. When the tuning task is completed, go to Tuning > Tuning results page to view the result list.
  3. In the Tuning results page, select a workload from the table.
    The Advisor recommendations page displays.
  4. Click the Table Organization menu to view the list of tables that can be converted to column-organized tables.

    From the table organization recommendation list, you can apply all recommendations by reviewing and running the script, or choose certain rows of recommendations to run.

    Note:
    • Changing the table organization for a Db2 OLTP database is not supported because EXPLAIN fails on statements containing column-organized tables.
    • Switching from row-based tables to column-organized tables might improve storage, query performance and usage of analytical workloads. However, switching to column-organized tables might not improve performance if transactional workloads are needed. To learn more about column-organized tables and their limitations, see Column-organized tables and Restrictions, limitations, and unsupported database configurations for column-organized tables.