SE_table_rebuild_index

Rebuilds object indexes.

Usage syntax

LONG SE_table_rebuild_index (SE_CONNECTION handle, const CHAR *table, LONG index_mask);

Parameters
handle The connection handle
table The name of the table to rebuild indexes
index_mask Index mask determining the different types of indexes to rebuild
Description

This function rebuilds indexes for a DBMS table. Indexes on registered tables are rebuilt based on the index_mask or all. The default index_mask is "all". Index stats for all indexes are recalculated.

The valid values for the index_mask are:

SE_INDEX_RASTER - Rebuilds the indexes for the Raster tables.
SE_INDEX_SPATIAL - Rebuilds the spatial index table.
SE_INDEX_XML - Rebuilds the XML indexes.
SE_INDEX_VERSIONED - Rebuilds the indexes for the Adds and Deletes tables.
SE_INDEX_ALL - Rebuilds all valid indexes on the ArcSDE table.

The function will return the error "SE_INVALID_INDEX_MASK" if the index specified in index_mask parameter is not a valid index. If the index_mask is set to SE_INDEX_ALL, all the valid indexes are rebuilt.

Returns

SE_SUCCESS
SE_DB_IO_ERROR

SE_INVALID_POINTER

SE_INVALID_ETYPE_MASK

SE_NET_FAILURE

SE_OUT_OF_SVMEM

SE_TABLE_NOEXIST