Create Spatial Index-- Fields and controls

Use this window to create a spatial index on a spatial data column in the selected table. For information on how to use spatial indexes for improving query performance, see the DB2 Spatial Extender User's Guide and Reference.

Name
Layer column
Grid size
OK
Cancel



Name

Type the name of the new spatial index.

Layer column

Use this box to select the spatial data column to be indexed. You can select one of the table's spatial data columns that has been registered for a spatial layer.

Grid size

Type in the values that you want for the levels of grid for this spatial index. The grid sizes must be in increasing numerical order (finest to coarsest).

For more information about grid sizes for spatial indexes, see the DB2 Spatial Extender User's Guide and Reference.

Finest
Grid size for the finest grid level. The value can be a real number up to 2**32.
Middle
Grid size for the middle grid level. The value must be a positive real number. You can specify a middle grid level value that ranges from a minimum equal to the value specified in the Finest field to a maximum value of 2**32. You can also specify zero.
Coarsest
Grid size for the coarsest grid level. The value must be a positive real number. You can specify a coarsest grid level value that ranges from a minimum equal to the value specified in the Middle field to a maximum value of 2**32. You can also specify zero.