Geospatial NUSIs can be used by the Teradata Optimizer to speed access to geospatial data for queries that use single-table predicates and join predicates. For more information on Geospatial Indexes, see Geospatial Indexes.
The following geospatial methods can be used to form predicates:
- MBR_Filter
- ST_3DDistance
- ST_Contains
- ST_Crosses
- ST_Distance
- ST_Equals
- ST_Intersects
- ST_Overlaps
- ST_Touches
- ST_Within
- Within_MBB
- Intersects_MBB
- ST_Relate (if this predicate is configured to execute one of the above methods)
Predicates that use the ST_Distance and ST_3DDistance methods have a slightly different form than those that use the other listed methods.