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
);