17 SQL Statements for Indexing Spatial Data

This chapter describes the SQL statements used when working with the spatial object data type. The statements are listed in the following table.

Table 17-1 Spatial Index Creation and Usage Statements

Statement	Description
ALTER INDEX	Alters specific parameters for a spatial index.
ALTER INDEX REBUILD	Rebuilds a spatial index or a specified partition of a partitioned index.
ALTER INDEX RENAME TO	Changes the name of a spatial index or a partition of a spatial index.
CREATE INDEX	Creates a spatial index on a column of type SDO_GEOMETRY.
DROP INDEX	Deletes a spatial index.

This chapter focuses on using these SQL statements with spatial indexes. For complete reference information about any statement, see Oracle Database SQL Language Reference.

Bold italic text is often used in the Keywords and Parameters sections in this chapter to identify a grouping of keywords, followed by specific keywords in the group. For example, INDEX_PARAMS identifies the start of a group of index-related keywords.