DESCRIBE AS JSON INDEX

You can retrieve a JSON representation of an index by using the DESCRIBE AS JSON INDEX statement:

DESCRIBE AS JSON INDEX index_name ON table_name

where:

  • index_name is the name of the index you want to describe.

  • table_name is the name of the table to which the index is applied.