Hi all, I have an abstract Animal class and two children, Dog and Cat. In my application I have to execute the following queries:
SELECT FROM Animal WHERE name = 'fluffy' AND age > 2 SELECT FROM Dog WHERE name = 'fluffy' AND age > 2 SELECT FROM Cat WHERE name = 'fluffy' AND age > 2 To optimize query execution I think I should create a composite index on name and age. Should I create an index for each class (Animal, Dog, Cat) or just for the ancestor (Animal)? Thanks, Riccardo -- --- 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/groups/opt_out.
