Hi Alessandro, Thank for your response, it's working, understood the logic.
However, as a result, the query is doing fully cluster scan (verified), so the query performance is just similar to using alias. My Best, Hung Tran On Thursday, January 28, 2016 at 3:24:29 PM UTC+7, [email protected] wrote: > > Hi, > try this query > > select from (select @rid, Statistics.NumActiveContacts from ContactList > where (Account = #20:0) and (EntityInfo.State = 0)) order by Statistics > asc, @rid asc skip 0 limit 5 > > Kind regards, > Alessandro > -- --- 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.
