Hello Ivan,
This query...
SELECT FROM Contact WHERE (OwnedBy.EntityInfo.State <> 200) AND (Account =
#20:2)
AND (EntityInfo.State = 0) ORDER BY EmailAddress ASC skip 10 limit 10
is explained as
{
"result": [
{
"@type": "d",
"@version": 0,
"documentReads": 100000,
"fullySortedByIndex": false,
"documentAnalyzedCompatibleClass": 100000,
"recordReads": 100000,
"fetchingFromTargetElapsed": 5674,
"indexIsUsedInOrderBy": false,
"compositeIndexUsed": 1,
"current": "#41:260870",
"involvedIndexes": [
"Contact.Account"
],
"limit": 10,
"orderByElapsed": 78,
"evaluated": 100000,
"user": "#5:0",
"elapsed": 5772.321,
"resultType": "collection",
"resultSize": 10,
"@fieldTypes":
"documentReads=l,documentAnalyzedCompatibleClass=l,recordReads=l,fetchingFromTargetElapsed=l,compositeIndexUsed=l,current=x,involvedIndexes=e,orderByElapsed=l,evaluated=l,user=x,elapsed=f"
}
],
"notification": "Query executed in 5.8 sec. Returned 1 record(s)"
}
This query...
SELECT FROM Contact WHERE (Account = #20:2) AND (EntityInfo.State = 0)
ORDER BY EmailAddress ASC skip 10 limit 10
is explained as
{
"result": [
{
"@type": "d",
"@version": 0,
"documentReads": 100000,
"fullySortedByIndex": false,
"documentAnalyzedCompatibleClass": 100000,
"recordReads": 100000,
"fetchingFromTargetElapsed": 4215,
"indexIsUsedInOrderBy": false,
"compositeIndexUsed": 1,
"current": "#41:260870",
"involvedIndexes": [
"Contact.Account"
],
"limit": 10,
"orderByElapsed": 78,
"evaluated": 100000,
"user": "#5:0",
"elapsed": 4317.759,
"resultType": "collection",
"resultSize": 10,
"@fieldTypes":
"documentReads=l,documentAnalyzedCompatibleClass=l,recordReads=l,fetchingFromTargetElapsed=l,compositeIndexUsed=l,current=x,involvedIndexes=e,orderByElapsed=l,evaluated=l,user=x,elapsed=f"
}
],
"notification": "Query executed in 4.355 sec. Returned 1 record(s)"
}
This query...
SELECT FROM Contact WHERE (OwnedBy.EntityInfo.State <> 200) AND (EntityInfo.
State = 0) ORDER BY EmailAddress ASC skip 10 limit 10
is explained as
{
"result": [
{
"@type": "d",
"@version": 0,
"fullySortedByIndex": true,
"documentReads": 20,
"current": "#41:80999",
"documentAnalyzedCompatibleClass": 20,
"recordReads": 20,
"involvedIndexes": [
"IX_Contact_EmailAddress"
],
"fetchingFromTargetElapsed": 344,
"indexIsUsedInOrderBy": true,
"evaluated": 20,
"user": "#5:0",
"elapsed": 349.00833,
"resultType": "collection",
"resultSize": 10,
"@fieldTypes":
"documentReads=l,current=x,documentAnalyzedCompatibleClass=l,recordReads=l,involvedIndexes=e,fetchingFromTargetElapsed=l,evaluated=l,user=x,elapsed=f"
}
],
"notification": "Query executed in 0.365 sec. Returned 1 record(s)"
}
And this query...
SELECT FROM Contact WHERE (OwnedBy.EntityInfo.State <> 200) AND (Account =
#20:2)
AND (EntityInfo.State = 0) skip 10 limit 10
is explained as
{
"result": [
{
"@type": "d",
"@version": 0,
"documentReads": 20,
"fullySortedByIndex": false,
"documentAnalyzedCompatibleClass": 20,
"recordReads": 20,
"fetchingFromTargetElapsed": 0,
"indexIsUsedInOrderBy": false,
"compositeIndexUsed": 1,
"current": "#41:260923",
"involvedIndexes": [
"Contact.Account"
],
"limit": 10,
"evaluated": 20,
"user": "#5:0",
"elapsed": 26.85809,
"resultType": "collection",
"resultSize": 10,
"@fieldTypes":
"documentReads=l,documentAnalyzedCompatibleClass=l,recordReads=l,fetchingFromTargetElapsed=l,compositeIndexUsed=l,current=x,involvedIndexes=e,evaluated=l,user=x,elapsed=f"
}
],
"notification": "Query executed in 0.043 sec. Returned 1 record(s)"
}
Thanks,
David
El miércoles, 11 de mayo de 2016, 14:24:19 (UTC+2), Ivan Mainetti escribió:
>
> Hello,
>
> could you post the result of the *EXPLAIN *of those queries?
>
> Thanks.
>
--
---
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.
