오라클 힌트를 사용해서 인텍스를 유효하게 했는데....

다른 아이디어가 있을까요?

SELECT /*+ 

    INDEX(E PK_TIXEVENTS)

    INDEX(LRI IDX_LRI_NUMBER1)

    INDEX(LR PK_LOTTERYREQUESTS)

    INDEX(O PK_OFFERS)

*/

  MAX(E.TIXEVENTENDDATE)

FROM TIXEVENTS E

JOIN LOTTERYREQUEST_ITEMS LRI ON E.TIXEVENTID = LRI.NUMBER1

JOIN LOTTERYREQUESTS LR ON LRI.LOTTERYREQUEST_ID = LR.ID

JOIN OFFERS O ON LR.LOTTERY_ID = O.ID

;