Geospatial Predicates & the Optimizer | Geospatial Data Types | Teradata Vantage - 17.10 - Geospatial Predicates and the Optimizer - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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:
Predicates that use the ST_Distance and ST_3DDistance methods have a slightly different form than those that use the other listed methods.