Hi Erik, Right now there is no support for such use case, you can define an index on both fields but it will be used only for one of them. I can think to a hack in 2.2, using a spatial index and doing a 2D spatial search, but again, it would be a hack.
Thanks Luigi 2016-02-28 12:43 GMT+01:00 Erik Pragt <[email protected]>: > 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. > -- --- 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.
