“Views” are actually virtual database tables that can be queried like regular tables of a database.
This feature has been optimized in MariaDB as only those tables are queried that are required by the query. This adds to the better performance of the database.
Where in MySQL, when you query a view, all the tables that are connected to the view are queried, regardless of the fact that the query may not require some of those views.