Strategy for fragmenting indexes

When you fragment a table, the indexes that are associated with that table are fragmented implicitly, according to the distribution scheme that you use, except for the round-robin fragmentation scheme when automatic location is enabled. Indexes on tables that use the round-robin distribution scheme are not fragmented when the AUTOLOCATE configuration parameter or environment option is set to a positive integer. You can use the FRAGMENT BY clause of the CREATE INDEX statement to fragment the index on any table.When you fragment a table, the indexes that are associated with that table are fragmented implicitly, according to the distribution scheme that you use. You can use the FRAGMENT BY clause of the CREATE INDEX statement to fragment the index on any table.

Each index of a fragmented table occupies its own tblspace with its own extents.