Hello, indexing is crucial for performance. Should I consider indexing edge points in vertices and in/out point in edges or does OrientDB handles those indexing automatically?
To the best of my knowledge, for traversals it will have no performance impact as the node already stores direct pointer to the edge.
Indexes are great only in situations where you are querying a large number of rows and you need to search based on a property. Say you wrote a query like
select * from V where out = xyz. I can’t think of a very valid reason for running such a query but may be you have a use case there.