VοΚtBBEkBVE\EBVEPBBEFEι₯bEλ
jβΝjBBEXPLAN PLAN EEEJE  mAqAθ€λ₯uEbETEPEEPAzNBZ
GgJ
BBOSBBWindows NT 4.0
      Oracle Oracle8
server
AEAzEBVENAzjβΝjA}BuPRIMARY
KEYA    ο€qTlwALAjAAAλSQLnNAkBuINDEXATlwAIAμ€nAAZμΉη€zNBZLλ²tAkAP
TABLE "T_TEST"A}CVI AzAθ€AqPRIMARY KEYARξΐAIAμ€jAAAJAP
nvPηPRIMARY KEY
| ALTER TABLE T_TEST ADD ( CONSTRAINT T_TEST_PKEY PRIMARY KEY ( A_NO ,A_KNO ,B_NO ,B_KNO ,A_SURYO ,B_SURYO ) USING INDEX PCTFREE 5 TABLESPACE IYT STORAGE ( INITIAL 100M NEXT 20M PCTINCREASE 0 ) ); | 
>> CASEvABBnvPη₯Eι₯AEJEκ₯
BVAzPΰΜA    ο€qTgκ€LA\SQL
 
| SQL> EXPLAIN PLAN 2 SET STATEMENT_ID = 'SIC' 3 FOR 4 SELECT A_NO FROM T_TEST 5 WHERE B_NO = 'B-001'; ExplainAq^N LAJALA\Bv SQL> SELECT DECODE(ID,0,'',LPAD(' ',3*(LEVEL - 1)) || '.' || POSITION)
      || ' '||
 QUERY_PLAN
 | 
>>BBLλ²tBBFULLNBRχ(INDEXATlAο€μ€nAANBRχ)APAο€μ€jAAAλ
********************************************************************************************************************************************
>> CASEvCBBnvPη₯Eι₯AEJEκ₯
BVAzRkXι€zPΰΜAqc~ALAjBu`[n  uAAAJAANBR      ο€qTgκ€LA\SQL
 
| SQL> EXPLAIN PLAN 2 SET STATEMENT_ID = 'SIC' 3 FOR 4 SELECT A_NO FROM T_TEST 5 WHERE A_NO LIKE 'A%'; ExplainAq^N LAJALA\Bv SQL> SELECT DECODE(ID,0,'',LPAD(' ',3*(LEVEL - 1)) || '.' || POSITION)
      || ' '||
 QUERY_PLAN
 | 
>>BBLλ²tBBINDEXATlAο€μ€\
********************************************************************************************************************************************
>> CASEvEBBnvPη₯Eι₯AEJEκ₯
BVAzRkXι€zPΰΜAqc~ALAjBuNεΚ  uAAAJAANBR      ο€qTgκ€LA\SQL
 
| SQL> EXPLAIN PLAN 2 SET STATEMENT_ID = 'SIC' 3 FOR 4 SELECT A_NO FROM T_Y2019 5 WHERE A_NO LIKE '%A'; ExplainAq^N LAJALA\Bv SQL> SELECT DECODE(ID,0,'',LPAD(' ',3*(LEVEL - 1)) || '.' || POSITION)
      || ' '||
 QUERY_PLAN
 | 
>>BBLλ²tBBFULLNBRχ(INDEXATlAο€μ€nAANBRχ)APAο€μ€jAAAλ
********************************************************************************************************************************************
>>BBCASEvGBBnvPη₯Eι₯AEJEκ₯
BVAzRkXι€zPΰΜA    ο€qGJAΰSQL
 
| SQL> EXPLAIN PLAN 2 SET STATEMENT_ID = 'SIC' 3 FOR 4 SELECT A_NO FROM T_TEST 5 WHERE A_NO LIKE 'A%' 6 AND A_KNO = '00010' 7 AND B_NO LIKE 'B%' 8 AND NL_KNO = '00010' 9 AND A_SURYO IS NOT NULL 10 AND B_SURYO IS NOT NULL 11 ; ExplainAq^N LAJALA\Bv SQL> SELECT DECODE(ID,0,'',LPAD(' ',3*(LEVEL - 1)) || '.' || POSITION)
      || ' '||
 QUERY_PLAN
 | 
>>BBLλ²tBBINDEXATlAο€μ€\
********************************************************************************************************************************************
>>BB LλΟ^BBnvPη₯Eι₯AEJEκ₯ BVAzRkXι€zPΰΜA JAJAnAASQLnNA}BuINDEXATlwAIAμ€nAA
>>BB c~Xθ  mwAnPΰΜAzINDEXA  ξΐAPAλ