In August, MariaDB Corporation released major versions of MariaDB Enterprise Server 10.6 and MariaDB Community Server 10.6 which include useful new features. One of these new features is IGNORED indexes. The ability to ignore indexes makes it easier to determine if specific indexes are useful for improving query performance.
We use indexes to improve query performance in transactional and OLTP workloads. But, sometimes an index can become redundant due to schema changes that modify table structure, application upgrades that modify database queries, MariaDB upgrades that implement new query execution optimizations, or changes to the table’s data that result in different optimizations being chosen for query execution.