- Generate index definition from query
- Return a curl command to PUT fts index on a node hosting the search service.
- Also compare the generated index definition with existing index definitions in the system for user to choose from based on a "sargability score".
- Support a CREATE INDEX command for FTS indexes (MB-48298)
- Once the command is supported, the index advisor can recommend a CREATE INDEX command as opposed to a curl command.
- CBO based cost between GSI vs FTS