--조인쿼리
SELECT A.UNO, GNO, REPLY_DEPTH, MEMB_ID, NICKNAME, SUBJECT, ADMINNOTICE_YN, READ_CNT, A.INS_DATE, DEL_YN, UPLOAD_MULTIMEDIA_TYPE,
(SELECT COUNT(*) AS COMMENT_CNT FROM TBWB_BOARD_COMMENT_A01 WHERE DEL_YN <> \'Y\' AND MASTER_UNO = A.UNO) COMMENT_CNT
FROM TBWB_BOARD_A01 A
INNER JOIN (SELECT UNO FROM TBWB_BOARD_A01_CONTENT WHERE (CONTENT LIKE \'%123%\')) B ON A.UNO = B.UNO
WHERE ADMINNOTICE_YN = \'N\' AND DEL_YN = \'N\'
USING INDEX IX_TBWB_BOARD_A01_U (+)
--일반쿼리
SELECT A.UNO, GNO, REPLY_DEPTH, MEMB_ID, NICKNAME, SUBJECT, ADMINNOTICE_YN, READ_CNT, A.INS_DATE, DEL_YN, UPLOAD_MULTIMEDIA_TYPE,
(SELECT COUNT(*) AS COMMENT_CNT FROM TBWB_BOARD_COMMENT_A01 WHERE DEL_YN <> \'Y\' AND MASTER_UNO = A.UNO) COMMENT_CNT
FROM TBWB_BOARD_A01 A
WHERE ADMINNOTICE_YN = \'N\' AND DEL_YN = \'N\' AND CONTENT LIKE \'%123%\'
USING INDEX IX_TBWB_BOARD_A01_U (+)
|