Hi Luca,

The system does not allow me to do that,

CREATE INDEX Contact.EntityInfo_State ON Contact (EntityInfo.State) 
NOTUNIQUE

will generate an error

com.orientechnologies.orient.core.index.OIndexException: Index with name : 
'Contact.EntityInfo_State' cannot be created on class : 'Contact' because 
field: 'EntityInfo.State' is absent in class definition.

I could not create any kind of index on a component field aka a field of 
embedded class.

My Best,
Hung Tran

On Friday, January 22, 2016 at 2:14:14 PM UTC+7, Luca Son wrote:
>
> Hi Hung Tran,
>
> a possible approach would be to create an index SB -TREE EntityInfo.State 
> NOTUNIQUE instead of a NOTUNIQUE_HASH_INDEX to avoid the sorting in the use 
> of this index . This is because the indexes SB - TREE retain sorting , 
> making it unnecessary sorting operations (like ORDER BY).
>
> Hope it helps
>

-- 

--- 
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.

Reply via email to