SQL Statements That Perform Fragmentation Tasks

Home | Previous Page | Next Page Disk, Memory, and Process Management > Table Fragmentation and PDQ > Fragmentation >

SQL Statements That Perform Fragmentation Tasks

To perform most fragmentation tasks, you use appropriate SQL statements. Table 22 lists the fragmentation tasks and the SQL statements to accomplish these tasks.

For details on how to accomplish these fragmentation tasks, refer to the IBM Informix: Database Design and Implementation Guide. For the syntax of these SQL statements, refer to the IBM Informix: Guide to SQL Syntax.

Table 22. Fragmentation Tasks and Corresponding SQL Statements
Fragmentation Task	SQL Statements
Creating a new fragmented table	CREATE TABLE statement, FRAGMENT BY clause
Creating a fragmented table from a single nonfragmented table	ALTER FRAGMENT statement, INIT clause
Creating a fragmented table from more than one nonfragmented table	ALTER FRAGMENT statement, ATTACH clause
Modifying distribution scheme for a fragmented table	ALTER FRAGMENT statement, INIT clause
Adding a fragment to a table	ALTER FRAGMENT statement, ATTACH clause
Removing a fragment from a table	ALTER FRAGMENT statement, DETACH clause
Reinitializing a fragmentation scheme	ALTER FRAGMENT statement, INIT clause
Converting a fragmented table to a non-fragmented table	ALTER FRAGMENT statement, INIT clause
Creating a fragmented index	CREATE INDEX statement
Adding an explicit rowid column to a fragmented table	Not supported