The etx_CloseIndex() routine
The etx_CloseIndex() routine closes an etx index.
Syntax
etx_CloseIndex( index_name)| Element | Purpose | Data type |
|---|---|---|
| index_name | Name of the index to close. | LVARCHAR |
Return type
None.
Usage
The first time an etx index is used in a query (opened), resources such as shared memory are allocated in the database server, and they continue to be allocated even after the query has finished executing. Subsequent user sessions that use the etx index share these resources. Since new resources are not allocated for each session while the index is open, query performance is improved.
When opened, an etx index does not automatically
free the shared resources until the database server shuts down. To
force an index to be closed, and thus free the resources, execute
the procedure etx_CloseIndex().
Tip: Leave etx indexes
left open, since the performance of queries that use the index is
improved for subsequent user sessions. You need only use the etx_CloseIndex() procedure
when database server resources become scarce and shared memory must
be freed.
Example
The following example closes the etx index reports_idx5:
EXECUTE PROCEDURE etx_CloseIndex ('reports_idx5');