Geospatial Predicates & the Optimizer | Geospatial Data Types | Teradata Vantage - 17.05 - Geospatial Predicates and the Optimizer - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1181-170K

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.