Neo4j: deprecated indexes and auto index vs new label base
I am currently looking at the best way to index our data and as I see there are three options
1). Outdated indexes. (IndexManager API)
2). Automatic indexes (neo4j.properties: node_auto_indexing = true, ode_keys_indexable = name, age, relationship_auto_indexing = true, relationship_keys_indexable = name, age)
3). Indexing support with support for new schema using labels.
Both options 1 and 2 have the advantage that indexes can be managed on both nodes and relationships. But legacy indexes have to be managed at the application level (which is not so nice, especially if you are used to RDBMS).
Option 3 does not provide support for relationship indexes. I understand that the need for relation indexes is minor, but still very convenient and powerful (depending on how the graph is modeled). Are there any plans to add relationship indexes to the new schema manager?
Would it work if, for example, I index the nodes using the Schema Manager, and the index labels and relationships using automatic indexing (neo4j.properties)?
His understanding is that the Schema Manager is deprecating the old IndexManager (obviously calling it now called deprecated indexes), but thus automatic indexing (neo4j.properties) now also falls under deprecated indexes? And what are the future plans for automatic indexing and schema manager?
Thank.
source to share
Would it work if, for example, I index the nodes using the Schema Manager, and the index labels and relationships using automatic indexing (neo4j.properties)?
YES
I doubt we will support rel-indexes, we will most likely add some form of vertical indexing. This is usually a graph model question that forces you to use rel-indexes.
The IndexManager will go away when we integrate full-text and spatial indexes as well as the old automatic indexing.
Schema indices will be automatically used by the cypher query scheduler and will also provide statistics for future work.
source to share