Sort Order is wrong with Link

[Hung Tran]

Hi,

I am using OrientDB version 2.1.8.

Remarks, it works when I alias Statistics.NumActiveContacts as v1, but the query will take long on a table > 50k records. See more details at Query is extremely slow when ORDER BY an alias

Any idea will be appreciated!

My Best,

Hung Tran

[alessand...@gmail.com]

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

[Hung Tran]

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