These queries are executed on OrientDB v1.7.8. And the Contact table only contains 110962 rows.
1/ A query with null in where take too long to complete. It usually takes 3-6 seconds.
select from Contact where Account is null
select from Contact where OwnedBy is null
2/ "Select count(1) from Contact" takes 3.149 second
Any suggestion will be appreciated!