The ONLINE keyword rebuilds the index without blocking the index that is, queries can use the spatial index while it is being rebuilt. All rows in the underlying table are processed before the insertion of index data is committed, and this requires adequate rollback segment space. Spatial index creation involves creating and inserting index data, for each row in the underlying table column being spatially indexed, into a table with a prescribed format. (If PARALLEL is specified without an integer value, the Oracle database calculates the optimum degree of parallelism.)Īn ALTER INDEX REBUILD 'rebuild_params' statement rebuilds the index using supplied parameters. See the Usage Notes for the CREATE INDEX statement for guidelines and restrictions that apply to the use of the PARALLEL keyword. For parallel execution you can specify an integer value of degree of parallelism.
SCHEDULE OUTLOOK REBUILD INDEX SERIAL
Is the same as PCTINCREASE in the STORAGE clause of a CREATE TABLE statement.Ĭontrols whether serial (NOPARALLEL) execution or parallel (PARALLEL) execution is used for the rebuilding of the index and for subsequent queries and DML operations that use the index. Is the same as MAXEXTENTS in the STORAGE clause of a CREATE TABLE statement. Is the same as MINEXTENTS in the STORAGE clause of a CREATE TABLE statement. Is the same as NEXT in the STORAGE clause of a CREATE TABLE statement. Is the same as INITIAL in the STORAGE clause of a CREATE TABLE statement. Same as TABLESPACE in the STORAGE clause of a CREATE TABLE statement. Specifies the tablespace in which the index data table is created. The following is a list of the supported subset. Not all physical storage parameters that are allowed in the STORAGE clause of a CREATE TABLE statement are supported. A spatial index data table is a regular Oracle table with a prescribed format.
Default = 10.ĭetermines the storage parameters used for rebuilding the spatial index data table. Slots that are left empty can be filled later when new data is inserted into the table. Specifies the minimum percentage of slots in each index tree node to be left empty when the index is created. Specifying a value greater than the default can significantly improve index creation performance however, do not specify more than 20 percent of available memory. If the specified number of bytes cannot be allocated, 64000 (about 64 KB) is allocated. Specifies the amount of maximum memory that can be allocated to perform a spatial index build or rebuild operation. For usage information related to three-dimensional geometries, see Three-Dimensional Spatial Objects. Must be less than or equal to the number of actual dimensions. For example, a value of 2 causes only the first two dimensions to be indexed. Specifies the number of dimensions to be indexed. See the Usage Notes for the CREATE INDEX statement for more information. For example, if you insert 3500 rows into the spatial table and then perform a commit operation, the updates to the spatial index table are performed in four batches of insert operations (1000, 1000, 1000, and 500). Specifies the number of index updates to be processed in each batch of updates after a commit operation.
In addition, specifying POINT allows for optimized processing of point data. The value must be from the Geometry Type column in SDO_GTYPE (except that UNKNOWN_GEOMETRY is not allowed). Specifies in a command string the index parameters to use in rebuilding the spatial index.įor an online rebuild operation (ALTER INDEX REBUILD ONLINE), performs cleanup operations on tables associated with the older version of the index.Ĭhecks to ensure that all geometries are of a specified geometry type.
0 kommentar(er)
