R-tree index options

These topics discuss the options to the CREATE INDEX command that R-tree indexes support.

The FRAGMENT clause
The IN clause
R-tree indexes are stored in dbspaces. If you do not specify an IN clause when you create an R-tree index, the index is stored in the same dbspace or dbspaces as the table on which it is built and inherits the distribution scheme of the table.

Parent topic: Create R-tree indexes

Copyright© 2019 HCL Technologies Limited