Discussion:
[orientdb] InvolvedIndex issue when executing Explain query
axon musthaq
2018-11-17 05:29:53 UTC
Permalink
i have created several indexes in an vertex class

example

VERTEX
1.employee as an index firstname
2.class employee_details as an index company

EDGE

employee_belongs_company

i wrote a query

select firstname,out('employee_belongs_company').company from employee

when i execute above query through

Explain

it does not contain any involved_index property.

kindly suggest how to add involved_indexes if there is no index
--
---
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 orient-database+***@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Luigi Dell'Aquila
2018-11-19 08:40:15 UTC
Permalink
Hi

I'm not sure I got the point, could you please provide a full SQL script to
reproduce the problem?

Thanks

Luigi
Post by axon musthaq
i have created several indexes in an vertex class
example
VERTEX
1.employee as an index firstname
2.class employee_details as an index company
EDGE
employee_belongs_company
i wrote a query
select firstname,out('employee_belongs_company').company from employee
when i execute above query through
Explain
it does not contain any involved_index property.
kindly suggest how to add involved_indexes if there is no index
--
---
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
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 orient-database+***@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Loading...