User's Guide and Reference

Using the Control Center to create a spatial index

To create a spatial index using the Control Center:

1. In the object tree, select the Tables folder. All existing tables are displayed in the contents pane.
2. From the contents pane, right-click the table that you want to create an index for, and click Spatial Extender --> Spatial Indexes in the pop-up menu. The Spatial Indexes window opens.
3. From the Spatial Indexes window, click Create. The Create Spatial Index window opens.
4. In the Name field, type the name of the new spatial index that you want to create.

   Note:

   You do not need to specify a schema. DB2 Spatial Extender will automatically add the schema and create a fully qualified name for you.

5. In the Layer column field, select the layer that you are creating an index for.

   A layer is a spatial column defined or registered to DB2 Spatial Extender.

6. In the Grid size fields, type the grid size value that you want to assign to each field.

   The grid levels, Finest, Middle, and Coarsest, are entered by increasing the cell size. Thus, the second level must have a larger cell size than the first, and the third larger than the second.