Thank you, Riccardo
2014-02-12 17:51 GMT+01:00 Andrey Lomakin <[email protected]>: > Hi, > Creation of index of Animal is enough. > > > On Wed, Feb 12, 2014 at 12:44 PM, Riccardo Tasso <[email protected] > > wrote: > >> 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. >> > > > > -- > Best regards, > Andrey Lomakin. > > Orient Technologies > the Company behind OrientDB > > -- > > --- > 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. > -- --- 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.
