About search index management
Overview of the integrated CQL search index commands for DSE Search.
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.
Tip: The index configuration pair (schema and config)
is stored and persisted in the DSE database table
solr_admin.solr_resources
.
Local node (optional) management of search indexing resources with dsetool commands.
Remember: In DSE authorization enabled environments, you must grant permission
to run search index commands; see Controlling access to search indexes.