Hi all, I have a document database with 1.000.000 Persons in it. Persons have a name, an age, and number of children. Now I want to find the persons who are older than 40 and have more than 3 children. This is taking a long time, because there's no index on the Persons table/collection.
What kind of index do I need to create to make this performant? Two indexes, one per field? One composite index? Any suggestions would be welcome! Thanks, Erik -- --- 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.
