Hi Luigi, I wanted to know if orientDB 3.0 and greater support multiple indexes now?
On Tuesday, April 7, 2015 at 11:47:56 AM UTC+5:30, Luigi Dell'Aquila wrote: > > Hi, > > current query executor cannot handle multiple indexes for multiple AND > clauses. > To do this you have to use a simple trick: execute two subqueries with LET > assignment and then use intersect() function. > eg. > > select intersect($a, $b) > let > $a = (<subquery1>), > $b = (<subquery2>) > > > 2015-04-04 14:10 GMT+02:00 <[email protected] <javascript:>>: > >> Is it possible to filter in a single query on multiple independent >> indexes ? >> If I have >> select from dealer >> WHERE city = 'wellington' >> AND name = 'james' >> >> >> where each city and name are separate indexes, is it possible to query >> on it and orientdb use both of the indexes ? Currently when running >> explain I see only one index being used, is it possible for orient to use >> both ? >> >> I know that I can use compound indexes but in my real case scenario I am >> trying to query both the lucene spatial and nounique index and I can't >> compound those. >> >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- --- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/orient-database/6944ca4a-9fd3-4201-ba0b-00d28d15cf46%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
