|
|
[ÀϹÝ] not in º¸´Ù´Â exist ¸¦ ¸¹ÀÌ »ç¿ëÇغ¸ÀÚ |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 121.¢½.39.7 |
ÀÐÀ½:2083 |
|
|
not in ¿¡ ´ëÇÑ Á¶°ÇÀº È¿À²ÀûÀÌÁö ¸øÇÔ
SELECT FINDAY
FROM DFIN_BP
WHERE RESTCD = 'RESTCD'
AND FINDAY >= '20110331'
AND FINDAY NOT IN (SELECT DEALDAY FROM STOCK_BP
WHERE RESTCD = 'RESTCD'
AND PRODCD = '»óÇ°ÄÚµå'
AND SEQ = 'SEQ'
AND DEALDAY >= '20110301'
GROUP BY DEALDAY) ;
SELECT FINDAY
FROM DFIN_BP
WHERE RESTCD = 'RESTCD'
AND FINDAYS >= '20110331'
AND FINDAY NOT IN (SELECT /*+ index( STOCK_BP IDX_STOCK_X0 ) */ DEALDAY FROM STOCK_BP
WHERE RESTCD = 'RESTCD'
AND PRODCD = '»óÇ°ÄÚµå'
AND SEQ = 'SEQ'
AND DEALDAY >= '20110301'
GROUP BY DEALDAY) ;
/*+ index( STOCK_BP IDX_STOCK_X0 ) */
-----------------------------------------------------
Äû¸®Æ©´× exist Á¶°ÇÀ» ÁÖ¾î¼ º¸´Ù È¿°úÀûÀÎ Äõ¸®¸¦ ±¸¼ºÇÑ´Ù.
SELECT A.FINDAY
FROM DFIN_BP A
WHERE A.RESTCD = 'RESTCD'
AND A.FINDAY >= '20110331'
AND NOT EXISTS ( SELECT 'X'
FROM STOCK_BP B
WHERE B.RESTCD = 'RESTCD'
AND B.PRODCD = '»óÇ°ÄÚµå'
AND B.SEQ = 'SEQ'
AND B.DEALDAY >= '20110301'
AND A.FINDAY = B.DEALDAY
GROUP BY DEALDAY) ;
SELECT * FROM V$MYSTAT ;
// Æ©´×Á¤º¸ -- analyize º¸´Ù ¾Æ·¡ ÇÁ·Î½ÃÁ®¸¦ µ¹·Á¼
Æ©´×ÇÏ´Â ÆíÀÌ ÁÁ´Ù°í ÇÔ
DBMS_STAT.GATHER_SYSTEM_STAT
DBMS_STAT.GATHER_SCHEMA_STAT
DBMS_STAT.GATHER_TABLE_STAT
|
|
|
|
|
|