-----------------------+
| Ignored                | Whether or not an index will be ignored by the    |
|                        | optimizer. See Ignored Indexes. From MariaDB      |
|                        | 10.6.0.                                           |
+------------------------+---------------------------------------------------+

The WHERE and LIKE clauses can be given to select rows using more general
conditions, as discussed in Extended SHOW.

Examples
--------

CREATE TABLE IF NOT EXISTS `employees_example` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `first_name` varchar(30) NOT NULL,
 `last_name` varchar(40) NOT NULL,
 `position` varchar(25) NOT NULL,
 `home_address` varchar(50) NOT NULL,
 `home_phone` varchar(12) NOT NULL,
 `employee_code` varchar(25) NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `employee_code` (`employee_code`),
 KEY `first_name` (`first_name`,`last_name`)
) ENGINE=Aria;

INSERT INTO `employees_example` (`first_name`, `last_name`, `position`,
`home_address`, `home_phone`, `employee_code`)
 VALUES
 ('Mustapha', 'Mond', 'Chief Executive Officer', '692 Promiscuous Plaza',
'326-555-3492', 'MM1'),
 ('Henry', 'Foster', 'Store Manager', '314 Savage Circle', '326-555-3847',
'HF1'),
 ('Bernard', 'Marx', 'Cashier', '1240 Ambient Avenue', '326-555-8456', 'BM1'),
 ('Lenina', 'Crowne', 'Cashier', '281 Bumblepuppy Boulevard', '328-555-2349',
'LC1'),
 ('Fanny', 'Crowne', 'Restocker', '1023 Bokanovsky Lane', '326-555-6329',
'FC1'),
 ('Helmholtz', 'Watson', 'Janitor', '944 Soma Court', '329-555-2478', 'HW1');

SHOW INDEXES FROM employees_example\G
*************************** 1. row ***************************
    Table: employees_example
 Non_unique: 0
  Key_name: PRIMARY
 Seq_in_index: 1
 Column_name: id
  Collation: A
 Cardinality: 6
  Sub_part: NULL
   Packed: NULL
    Null:
 Index_type: BTREE
   Comment:
Index_comment: 
   Ignored: NO
*************************** 2. row ***************************
    Table: employees_example
 Non_unique: 0
  Key_name: employee_code
 Seq_in_index: 1
 Column_name: employee_code
  Collation: A
 Cardinality: 6
  Sub_part: NULL
   Packed: NULL
    Null:
 Index_type: BTREE
   Comment:
Index_comment: 
   Ignored: NO
*************************** 3. row ***************************
    Table: employees_example
 Non_unique: 1
  Key_name: first_name
 Seq_in_index: 1
 Column_name: first_name
  Collation: A
 Cardinality: NULL
  Sub_part: NULL
   Packed: NULL
    Null:
 Index_type: BTREE
   Comment:
Index_comment: 
   Ignored: NO
*************************** 4. row ***************************
    Table: employees_example
 Non_unique: 1
  Key_name: first_name
 Seq_in_index: 2
 Column_name: last_name
  Collation: A
 Cardinality: NULL
  Sub_part: NULL
   Packed: NULL
    Null:
 Index_type: BTREE
   Comment:
Index_comment: 
   Ignored: NO

URL: https://mariadb.com/kb/en/show-index/https://mariadb.com/kb/en/show-index/