Before you begin

You can create an R-tree index on a table after you create a table that contains a column that has an appropriate data type.

If you plan to implement a DataBlade module, complete the following tasks before you create an R-tree index:
  1. Install a DataBlade module on your database server that includes the following objects:
    • A user-defined data type that can be indexed with an R-tree index
    • An operator class that specifies the functions to be used with the R-tree index
    • The support and strategy functions that are required by the operator class
  2. Create a database.
  3. Register the DataBlade module that is described in step 1 into your database with BladeManager.
  4. Create a table that contains one or more columns of the user-defined data type that can be indexed with the R-tree access method.
Important: The examples in these topics use objects that are defined in the sample Shapes3 DataBlade module that Shapes3 sample DataBlade module describes. These objects include the data type MyShape and the operator class MyShape_ops. Columns of data type MyShape can store points, boxes, and circles.
Parent topic: The R-tree secondary access method
Copyright© 2019 HCL Technologies Limited