STS_SubtrackDestroy function

The STS_SubtrackDestroy function stops the indexing of spatiotemporal search data and drops specified subtrack table.

Syntax

STS_SubtrackDestroy(
       subtrack_name   VARCHAR(128))
returns INTEGER
subtrack_name
The name of the subtrack table.

Usage

Run the STS_SubtrackDestroy function when you want to stop spatiotemporal indexing and drop the existing subtrack table. For example, when the subtrack tables become large, you can drop them and then restart spatiotemporal search indexing with a more recent start time.

Returns

0 = The subtrack table and its indexes are dropped.

1 = The specified subtrack table does not exist.

An exception = An error.

Example

The following statement stops spatiotemporal search indexing and deletes the ts_vehicle_subtrack subtrack table and its indexes:

BEGIN WORK;
EXECUTE FUNCTION STS_SubtrackDestroy('t_vehicle_subtrack');
COMMIT WORK;