Hi Mohammad,
Lucene indexes do not provide ordering (or better, they return results
based on their score, but it's not what you need).
What you can do here is define an additional NOTUNIQUE index on "name",
this will do the job
Thanks
Luigi
2018-03-31 23:45 GMT+02:00 Mohammad Hossein Ganjyar <
I have this problem with orientdb v2.2.31. I have vertex Users with
properties id (no index), name (lucene index), family(lucene index).
My quesry is :
SELECT @rid, name , family FROM profiles
order by name asc
limit 10
This query is very slow (exc in ~17 seconds).
Do you best idea?
thanks
On Fri
Hi,
Thank you for your answer. In attachment, the result of explain without
index
Thanks
Le vendredi 26 septembre 2014 11:50:12 UTC+2, Enrico Risa a écrit :
>
> Hi Etienne
>
> can you try to remove the not unique index
> and paste here the explain of
>
> *select from Tracks [Title, ArtistName
Hi Etienne
can you try to remove the not unique index
and paste here the explain of
*select from Tracks [Title, ArtistName, AlbumName] LUCENE 'daft+punk' order
by relevance desc*
Thanks
Enrico
2014-09-26 11:30 GMT+02:00 Etienne Crinier :
> Hi,
>
> I have a 'fulltext lucene' index to do a qui
Hi,
I have a 'fulltext lucene' index to do a quick search on multiple fields.
It is working properly.
Now i would like to sort these results through a numeric field. Therefore,
I created a 'notunique' index to this field.
You can find below my request :
*select from Tracks [Title, ArtistName, A