Is there option to create secondary index for REGEXP_CONTAINS function it always uses primary scan,
Please note pattern for REGEXP_CONTAINS is not fixed
REGEXP_CONTAINS(expression, pattern)
e.g i m having index on description
but
select META().id from default where REGEXP_CONTAINS(description, ?) not using GSI on description