Operator Class

The sample DataBlade module defines the MyShape_ops operator class that you should use when you create R-tree indexes on columns of data type MyBox, MyCircle, and MyPoint.

The sample DataBlade module defines the MyShape_ops operator class as follows:

CREATE OPCLASS MyShape_ops FOR RTREE
STRATEGIES (Overlap, Equal, Contains, Within)
SUPPORT (Union, Size, Inter, SFCbits, ObjectLength, SFCvalue, SetUnion);

The operator class specifies the four required strategy functions (Overlap, Equal, Contains, and Within), the three required support functions (Union, Size, and Inter), as well as the four optional bulk-loading support functions (SFCbits, ObjectLength, SFCValue, and SetUnion.)

The following example shows how to specify the MyShape_ops operator class when you create an R-tree index:

CREATE INDEX box_tab_index
ON box_tab ( boxes MyShape_ops )
USING RTREE;