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λ