Is This Content Helpful?
We're glad to know this article was helpful.
There is no separate spatial index table in SDE 3.x for Informix as there is in other implementations of SDE 3.x, such as SDE for Oracle. Instead, the spatial index is implemented as a special database index on the business table's spatial column. This index is called an RTREE index.
The RTREE index
The two-dimensional RTREE index differs from the traditional hierarchical BTREE index provided by the Informix Dynamic Server software. The BTREE index cannot be applied to a spatial column because the two-dimensional characteristic of the spatial column requires an RTREE index. For the same reason, an RTREE index cannot be applied to a non-spatial column or a composite column. The RTREE create index syntax includes the additional USING RTREE clause to create an RTREE index rather than a BTREE index. The full syntax is:
create index on ( SqlSde_Ops) using rtree;
update statistics for table