MariaDB uses indexes intensely to optimize queries given quick access to data and gave statistics. There are some users found indexes are complicated to manage. MariaDB provides a self-sufficient storage engine along with the availability of statistics table. Statistics are calculated by storage engine for every table in every storage engine. storage engine even calculates the statistics for columns that are not indexed.

BY Best Interview Question ON 13 Jan 2019