The FRAGMENT clause

R-tree indexes can be fragmented by expression. You cannot, however, fragment R-tree indexes on the multidimensional column they index.

For example, if you create an R-tree index on a column of type MyShape, you cannot specify this column in the fragment clause. You must fragment the R-tree index on another column of a standard data type, such as INTEGER or VARCHAR.

If you create an R-tree index on a fragmented table in a dbspace with the default page size, the R-tree index is also fragmented by default. The index fragments are automatically stored in the same dbspace as the table fragments. You cannot create an R-tree index on a fragmented table in a dbspace with a non-default page size.