Details
-
Epic
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
Dynamic indexes creation
Description
Executing dynamic index management with CREATE/DROP INDEX commands requires specific management of index lifecycle.
It includes at least:
- Triggering necessary operation on affinity nodes (nodes hosting data of a table with new index).
- Adding information about new index to configuration.
- Monitoring process of index creation and updating index status.
- Providing notification mechanism to SQL engine so index will be used if and only if it is fully built and ready to be used.
- Cancelling operation and cleaning stuff up in case user drops index.