For more information on how geospatial indexes and predicates can speed geospatial queries, see Geospatial Predicates and the Optimizer .
- Geospatial NUSIs must be single-column indexes.
- Geospatial NUSIs cannot be created on geospatial columns used in join indexes.
- The ALL keyword is not supported for geospatial indexes.
- The ORDER BY VALUES and ORDER BY HASH clauses are not supported for geospatial indexes.
- Geospatial indexes cannot be created on global temporary or volatile tables. Consequently, the TEMPORARY keyword is not supported for geospatial indexes.
- Geospatial indexes can be created for 3D data, however the z coordinate is ignored. The MBR of the geometry, which is based only on the x and y coordinates, is used to create the index.
- Because geospatial indexing is based on x and y coordinates, performance can be adversely affected by indexing if 3D geospatial objects being indexed are stacked in the z axis, with very little distribution in the x and y axes.
For more information about indexes, see Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144 and Teradata Vantage™ - Database Design, B035-1094. For more information on the Hilbert R-tree structure, see Teradata Vantage™ SQL Request and Transaction Processing, B035-1142.