About search index management
Use the following DSE Search CQL commands to manage search indexes:
-
CREATE SEARCH INDEX
Generates a new search index on an existing table with default schema and config. -
DESCRIBE SEARCH INDEX
Displays the active or pending schema or config in XML format. -
ALTER SEARCH INDEX CONFIG
Modifies the search index config. After modifying, use reload to push the changes live. -
ALTER SEARCH INDEX SCHEMA
Modifies the search index schema. After modifying, use reload to push the changes live. -
RELOAD SEARCH INDEX
Loads pending changes to the index schema and config. Some changes such as adding or removing indexed fields require a rebuild. -
REBUILD SEARCH INDEX
Reconstructs the search index using the active schema and config. -
COMMIT SEARCH INDEX
Forces a reload of data into the index after data is added, modified, or removed from the corresponding CQL table. -
DROP SEARCH INDEX
Removes the search index and corresponding files.
The index configuration pair (schema and config) is stored and persisted in the DSE database table |
Local node (optional) management of search indexing resources with dsetool
commands.
In DSE authorization enabled environments, you must grant permission to run search index commands; see Controlling access to search indexes. |