Hi Alessandro, You could see the query in each image. Anyway, here they are
SELECT @rid as __x1, Email.Address, Status, OwnedBy.Name FROM Contact ORDER BY __x1 DESC skip 0 limit 10 // took 3.941 sec SELECT @rid, Email.Address, Status, OwnedBy.Name FROM Contact ORDER BY @rid DESC skip 0 limit 10 // took 0.016 sec I have also tested with other fields, that shows "ORDER BY an alias" will do a fully cluster scan My Best, Hung Tran On Thursday, January 21, 2016 at 11:39:04 PM UTC+7, [email protected] wrote: > > Hi, > can you post the complete query ? > > 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.
