MySQL 8.0 Hint for set value parameter

Syntax : SET_VAR ( << input your session parameter >> )

 

SELECT /*+ SET_VAR(join_buffer_size = 1048576) */

       CountryCode, country.Name AS Country,

       city.Name AS City, city.District

  FROM world.country IGNORE INDEX (Primary)

       INNER JOIN world.city IGNORE INDEX (CountryCode)

             ON city.CountryCode = country.Code

 WHERE Continent = 'Asia';