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.