There is an index type called TEXT INDEX in Neo4j which is designed for CONTAINS and END WITH search when I try to create an index in it. In traditional DB, contains query is not recommend, because it is hard to use the index. So I'm confused how Neo4j implements TEXT INDEX to support CONTAINS query.
Here is the screenshot from Neo4j's official site, https://neo4j.com/docs/operations-manual/current/performance/index-configuration/#index-configuration-text.