Does it make sense to create a vertex type with SQL, index with SQL but do all other queries in Cypher ?

[ExtReMLapin]

Hello,

We're for now running a relatively small database so we're not sure what i'm about to say make sense, performance wise.

We've been using arcade DB and cypher for few months at the office. We have nodes of the type NER that have a subtype, it would make sense to create an index of this subtype property which is a string.

I'm taking the bet ArcadeDB is already creating an index on the node type.

Would it make sense to create an index in SQL (as we can't in cypher) ? Would the cypher language make profit of this created index ?

create vertex type NER if not exists;
create property NER.subtype if not exists string;
create index if not exists on NER (subtype) unique

MATCH (n:NER{subtype: 'DATE'}) return COUNT(n)

We only have 200 elems of this subtype and the request with and without index always take 2029ms.

Thanks.

Found these discussions here but I'm not conviced it fit my question

#1417