I manage to get it working with:
*select subnames from Person where subnames containstext 'name'*
Is this the way to go?
But it seems that he is using the index. Is that right?
{
"result": [
{
"@type": "d",
"@version": 0,
"limit": -1,
"involvedIndexes": [
"person.subnames"
],
"current": "#13:6",
"evaluated": 2,
"fetchingFromTargetElapsed": 0,
"documentReads": 2,
"documentAnalyzedCompatibleClass": 2,
"recordReads": 2,
"elapsed": 23.784271,
"resultType": "collection",
"resultSize": 1,
"@fieldTypes":
"involvedIndexes=e,current=x,evaluated=l,fetchingFromTargetElapsed=l,documentReads=l,documentAnalyzedCompatibleClass=l,recordReads=l,elapsed=f"
}
],
"notification": "Query executed in 0.119 sec. Returned 1 record(s)"
}
Am Sonntag, 8. Februar 2015 11:33:05 UTC+1 schrieb Curtis Mosters:
>
> I mean I would like to create a class Person. And a Person shall have a
> property subnames. There the alternative names of that person shall be
> stored.
>
> I also would like to set an index on them.
>
> Is the EmbeddedList the best choice for this or is there anything similar
> to this?
>
> If possible please post all the SQL commands for that. I'm new to all the
> embedded things of OrientDB.
>
> 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.