MySQL 8.0 Hint for Query block

Syntax :  table_name@query_block in subquery  

 

SELECT /*+ NO_INDEX_MERGE(payment@payment) */

       rental_id, rental_date, return_date

  FROM sakila.rental

 WHERE rental_id IN (

         SELECT /*+ QB_NAME(payment) */

                rental_id

           FROM sakila.payment

          WHERE staff_id = 1 AND customer_id = 75

       );