[오라클] 조건 순서?

 

 

 

현재 8개의 리뷰 중 7개의 상태가 'Y', 1개의 상태가 'N'

MOVIE_ID는 모두 동일하게 1427 (== 향수)

 

조건 순서 1

SELECT COUNT(*)
		FROM REVIEW R
		LEFT JOIN MEMBER MB USING(USER_NO)
        LEFT JOIN MOVIE MV ON(R.MOVIE_ID = MV.MOVIE_ID)
		LEFT JOIN TV ON (R.MOVIE_ID = TV.TV_ID)
		WHERE REVIEW_STATUS = 'Y'
          AND TV.NAME LIKE '%향%' OR MV.TITLE LIKE '%향%';

 

 

 

조건 순서 2

SELECT COUNT(*)
		FROM REVIEW R
		LEFT JOIN MEMBER MB USING(USER_NO)
        LEFT JOIN MOVIE MV ON(R.MOVIE_ID = MV.MOVIE_ID)
		LEFT JOIN TV ON (R.MOVIE_ID = TV.TV_ID)
		WHERE TV.NAME LIKE '%향%' OR MV.TITLE LIKE '%향%'
          AND REVIEW_STATUS = 'Y';