oracle : exemple d'utilisation des HINT

Utilisation de HINT ... sous oracle. Ce n'est pas conseillé, mais parfois ça améliore considérablement les perfs ...


SELECT /*+ FIRST_ROWS */ *
FROM (SELECT *
FROM uneTableDeCommade tv
WHERE tv.no_cmd >= 1841541
AND tv.vers > 0
AND EXISTS (
SELECT 1
FROM uneTableActionCommande ta
WHERE tv.no_cmd = ta.no_cmd
AND tv.vers = ta.vers
AND ta.id_action > 0
AND ta.dh_deb >=TO_DATE ('01/03/2010 00:00:00','dd/mm/yyyy/ hh24:mi:ss'))
ORDER BY tv.no_cmd ASC)
WHERE ROWNUM <= 1000;