Displays information about specified indexes. SQL displays the
    name of the index, the associated column and table, the size
    of the index key, if the definition allows duplicate values for
    the column, the type of index (sorted or hashed), and whether
    index compression is enabled or disabled. If you specify the SHOW
    INDEXES statement without any arguments, SQL displays definitions
    of all indexes in all declared databases.

    You
    Specify
    This:       SQL Performs This Action:

    CARDINALITY Adds the index and column prefix cardinality values
                to the SHOW output.
    PARTITIONS  Displays the index partitions showing the partition
                name and number the name of the storage area used for
                the partition.