On 1 July 2016 at 15:05, Fabio Rinnone <[email protected]> wrote:
> In OrientDB I've tried this: > > select count(*) as total from ( select expand(in()) from demo where age > > 29 and age < 46 ) where drugname = 'TRIZIVIR' > > that return correct result, but I think that the use of subquery is not > efficient. > Did you create an INDEX (non hash) against demo.age and an HASH_INDEX against drugname? -- --- 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.
