Updating the index after data expires (TTL)
Time-To-Live (TTL) set on a CQL field also applies to the indexed values. The DSE Search engine searches the index for expired documents and then deletes them from the index in batches of a configurable size, as defined by the ttl_index_rebuild_options in the dse.yaml file. The default interval is 300 seconds (5 minutes).
For example, insert a row with a life of 60 seconds into the health_data demo:
INSERT INTO demo.health_data (id, age, gender) VALUES (9999,88,'female') USING TTL 60;
To force the index to update with the new data:
COMMIT SEARCH INDEX ON demo.health_data ;
In this configuration example, after 60 seconds, the row is removed from the CQL table and the search index.