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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1181-171K
Language
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.