Hi Luca, I tried, the result is the same. I used HASH_INDEX because I don't need ORDER BY on that, so HASH_INDEX should give the best performance for WHERE.
My Best, Hung Tran On Friday, January 22, 2016 at 4:30:16 PM UTC+7, Luca Son wrote: > > Hi Hung Tran, > > I understand, unfortunately it is not currently possible to create indexes > across multiple classes. > Could you try with this SB-TREE index ? > > CREATE INDEX EntityInfo.State ON EntityInfo (State) NOTUNIQUE > > instead of your HASH_INDEX > > CREATE INDEX EntityInfo.State ON EntityInfo (State) NOTUNIQUE_HASH_INDEX > > > Luca > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
