Geospatial Single-Table Predicates | Geospatial Data Types | Teradata Vantage - Geospatial Single-Table Predicates - Advanced SQL Engine - Teradata Database

Geospatial single-table predicates cause the optimizer to evaluate a geospatial index, if one exists, as a potential access path to the geospatial data. In these circumstances, the index can greatly speed access to the data and execution of the query. Supported single-table predicates, excluding the distance methods ST_Distance and ST_3DDistance, use any of the following forms:

SELECT a, b FROM TableName
WHERE TableName.GeoCol.SupportedGeoMethod(GeospatialLiteralExpression)=1

or

SELECT a, b FROM TableName
WHERE GeospatialLiteralExpression.SupportedGeoMethod(TableName.GeoCol) = 1

or

SELECT a, b, FROM  TableName
WHERE TableName.GeoCol IS NULL

Single-table distance predicates are those that use the ST_Distance and ST_3DDistance methods. They can use any of the following forms:

SELECT a, b FROM TableName
WHERE TableName.GeoCol.
SupportedGeoDistanceMethod(GeospatialLiteralExpression) < DistanceLiteral

or

SELECT a, b FROM TableName
WHERE GeospatialLiteralExpression.
SupportedGeoDistanceMethod(TableName.GeoCol) < DistanceLiteral

You can use either the < or <= operator to form these predicates.