RDB/MySQL

MySQL 8.0 Hint for Query block

세모데 2023. 6. 22. 18:58
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
       );