Organization percentage

When you view the status information for tables, such as usingvarious system views, the information contains an organization percentage. For clustered base tables (CBTs), the organization percentage shows the percentage of the table data that is organized based on the specified organizing keys for that table. Organized tables typically have a 100% organization percentage, while tables that are not yet organized have a 0% percentage. The organization percentage does not apply to tables which are not CBTs.

After you specify the organizing keys for the table and load its data, you typically run a GROOM TABLE RECORDS ALL command to reorganize the data according to the keys. After you insert any new data in the table, update the organization by using the GROOM TABLE RECORDS READY command to ensure that the organization is up-to-date.