show execution plan of a Oracle NoSQL query

34 views Asked by At

I am trying to validate the usage of an index but I cannot find a command allowing to show the current execution plan?

SELECT /*+ FORCE_INDEX(Persons idx_income) */ 
* from Persons
WHERE income > 10000000 and age < 40;

Is there a command to do this ? How to validate ?

1

There are 1 answers

0
Dario On BEST ANSWER

If you are using the shell utility, you can use the command show query that displays the query plan for a query.