How to see the details of an index in oracle NoSQL?

31 Views Asked by At

How to see the details of an index ? I am executing this command to see the indexes for a table

sql-> SHOW INDEXES ON Persons;
indexes
idx_age
idx_areacode
idx_income
idx_state_city_income

but how to see the details, I cannot find a command show indexes detail

1

There are 1 best solutions below

0
Dario On

There is no command show indexes detail, Use the command describe

sql-> describe as json index idx_state_city_income on Persons;
{
"name" : "idx_state_city_income",
"type" : "secondary",
"fields" : ["address.state", "address.city", "income"]
}