mysql> show index from documenti; +-----------+------------+----------+--------------+---------------+-----------+-------------+----------+--------+------+------------+----------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +-----------+------------+----------+--------------+---------------+-----------+-------------+----------+--------+------+------------+----------+ | documenti | 0 | PRIMARY | 1 | id | A | 1213 | NULL | NULL | | BTREE | | | documenti | 1 | titolo | 1 | titolo | NULL | 1213 | NULL | NULL | YES | FULLTEXT | disabled | | documenti | 1 | titolo | 2 | abstract | NULL | 1213 | NULL | NULL | YES | FULLTEXT | disabled | | documenti | 1 | titolo | 3 | testo | NULL | 1213 | NULL | NULL | YES | FULLTEXT | disabled | | documenti | 1 | titolo | 4 | area_tematica | NULL | 1213 | NULL | NULL | YES | FULLTEXT | disabled | +-----------+------------+----------+--------------+---------------+-----------+-------------+----------+--------+------+------------+----------+