MariaDB: USE INDEX


# USE INDEX [{FOR {JOIN|ORDER BY|GROUP BY}] ([index_list])


SELECT Name,CountryCode FROM City FORCE INDEX (Name)
  WHERE name>="A" and CountryCode >="A";

SELECT Name,Count(*) FROM City
  FORCE INDEX FOR GROUP BY (Name)
    WHERE population >= 10000000 GROUP BY Name;