Indexing LIKE predicates

SQL++
1

Have the following document as an example:

{
    "id": "9ed72dd0-8c8c-449b-91e5-880b8d864887",
    "type": "human",
    "name": "John David Smith"
}

Then consider the following query:

SELECT document.* FROM bucket
WHERE document.name LIKE "%David%"

How would one index the name field so that documents containing David can be queried efficiently?

2

Check this out https://dzone.com/articles/a-couchbase-index-technique-for-like-predicates-wi

3

Also, https://dzone.com/articles/more-than-like-efficient-json-search-with-couchbas