{"id":170,"date":"2008-04-21T05:16:51","date_gmt":"2008-04-21T05:16:51","guid":{"rendered":"http:\/\/apollo89.com\/wordpress\/?p=170"},"modified":"2013-02-13T12:25:40","modified_gmt":"2013-02-13T03:25:40","slug":"explain-plan%ec%9d%98-%ec%82%ac%ec%9a%a9%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/apollo89.com\/wordpress\/?p=170","title":{"rendered":"EXPLAIN PLAN\uc758 \uc0ac\uc6a9\ubc29\ubc95"},"content":{"rendered":"

 <\/p>\n

\uc774 \uc7a5\uc5d0\uc11c\ub294 \uc2e4\ud589 \uacc4\ud68d\uc5d0 \ub300\ud55c \uc18c\uac1c, SQL \ucee4\uba58\ub4dc\uc758 EXPLAIN PLAN\ub97c \ud574\uc124\ud558\uace0, \uadf8 \ucd9c\ub825\uc758 \ud574\uc11d \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4. \ub610\ud55c \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ud37c\ud3ec\uba3c\uc2a4 \ud2b9\uc131\uc744 \uc81c\uc5b4\ud558\ub294 OUT LINE \uc744 \uad00\ub9ac\ud558\ub294 \ud504\ub85c\uc2dc\uc800\uc5d0 \ub300\ud574 \uc54c\uc544 \ubd05\ub2c8\ub2e4.
\n\uc774 \uc7a5\uc740 \ub2e4\uc74c\uc758 \uc21c\uc11c\ub85c \uc9c4\ud589\ub429\ub2c8\ub2e4.<\/p>\n

\u25a0 EXPLAIN PLAN \uc5d0 \ub300\ud574
\n\u25a0 PLAN_TABLE \ucd9c\ub825\ud45c\uc758 \uc791\uc131
\n\u25a0 EXPLAIN PLAN \uc758 \uc2e4\ud589
\n\u25a0 PLAN_TABLE \ucd9c\ub825\uc758 \ud45c\uc2dc<\/p>\n

—————————————————————
\n\u25a0 EXPLAIN PLAN \uc5d0 \ub300\ud574
\n—————————————————————
\nEXPLAIN PLAN \ubb38\uc740 SELECT, UPDATE, INSERT \ubc0f DELETE \ubb38\uc5d0 \ub300\ud574 Oracle \uc635\ud2f0\ub9c8\uc774\uc838\uac00 \uc120\ud0dd\ud55c \uc2e4\ud589 \uacc4\ud68d\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4. \ubb38\uc7a5\uc758 \uc2e4\ud589 \uacc4\ud68d\uc774\ub780 Oracle\uc774 \uadf8 \ubb38\uc7a5\uc744 \uc2e4\ud589\ud558\uae30 \uc704\ud574 \uc2e4\uc2dc\ud558\ub294 \uc77c\ub828\uc758 \ucc98\ub9ac\uc785\ub2c8\ub2e4.<\/p>\n

\ud589 \uc18c\uc2a4\u00b7\ud2b8\ub9ac\ub294, \uc2e4\ud589 \uacc4\ud68d\uc758 \ud575\uc2ec\uc785\ub2c8\ub2e4.\ud589 \uc18c\uc2a4\u00b7\ud2b8\ub9ac\ub294 \ub2e4\uc74c\uc758 \uc815\ubcf4\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/p>\n

\ubb38\uc7a5\uc5d0 \uc758\ud574 \ucc38\uc870\ub418\ub294 \ud14c\uc774\ube14\uc758 \uc21c\uc11c
\n\ubb38\uc7a5\uc73c\ub85c \uc5b8\uae09\ub418\ub294 \uac01 \ud14c\uc774\ube14\uc5d0\uc758 \uc561\uc138\uc2a4 \ubc29\ubc95
\n\ubb38\uc7a5\uc758 \uacb0\ud569 \uc870\uc791\uc758 \uc601\ud5a5\uc744 \ubc1b\ub294 \ud14c\uc774\ube14\uc758 \uacb0\ud569 \ubc29\ubc95
\n\ud544\ud130, \uc18c\ud2b8, \uc9d1\uacc4\ub4f1\uc758 \ub370\uc774\ud130 \uc870\uc791<\/p>\n

PLAN TABLE \uc5d0\ub294, \ud589 \uc18c\uc2a4\u00b7\ud2b8\ub9ac\uc758 \uc678, \ub2e4\uc74c\uc758 \uc815\ubcf4\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\ucd5c\uc801\ud654.\uac01 \uc870\uc791\uc758 \ucf54\uc2a4\ud2b8\uc640 \uce74\ub514\ub098\ub9ac\ud2f0\uc5d0 \ub300\ud574
\n\ud30c\ud2f0\uc158\ud654.\uc561\uc138\uc2a4 \ub41c \ud30c\ud2f0\uc158\uc138\ud2b8 \ub4f1
\n\ud328\ub7ec\ub810 \uc2e4\ud589.\uacb0\ud569 \uc785\ub825\uc758 \ubc30\ubd84 \ubc29\ubc95 \ub4f1<\/p>\n

EXPLAIN PLAN\uc758 \uacb0\uacfc\uc5d0 \uc758\ud574 \uc635\ud2f0\ub9c8\uc774\uc838\uac00 \ud2b9\uc815\uc758 \uc2e4\ud589 \uacc4\ud68d(\uc608\ub97c \ub4e4\uc5b4 nested\u00b7\ub8e8\ud504 \uacb0\ud569)\uc744 \uc120\ud0dd\ud560\uc9c0\ub97c \ud310\ub2e8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610, \uc635\ud2f0\ub9c8\uc774\uc838\uc758 \uacb0\uc815(\uc608\ub97c \ub4e4\uc5b4 \uc635\ud2f0\ub9c8\uc774\uc838\uac00 \ud574\uc2dc \uacb0\ud569\uc774 \uc544\ub2c8\uace0 nested\u00b7\ub8e8\ud504 \uacb0\ud569\uc744 \uc120\ud0dd\ud55c \uc774\uc720)\uc5d0 \ub300\ud55c \uc774\ud574 \ub4f1 \ud37c\ud3ec\uba3c\uc2a4\ub97c \uc54c\uae30 \uc704\ud574\uc11c \ub3c4\uc6c0\uc774 \ub41c\ub2e4.<\/p>\n

\uc2e4\ud589 \uacc4\ud68d\uc758 \ubcc0\ud558\ub294 \uc774\uc720
\n———————–
\n\ucf54\uc2a4\ud2b8 \ubca0\uc774\uc2a4\u00b7 \uc635\ud2f0\ub9c8\uc774\uc838\ub97c \uc0ac\uc6a9\ud558\uba74 \uc2e4\ud589 \uacc4\ud68d\uc740 \uae30\ucd08\uac00 \ub418\ub294 \ucf54\uc2a4\ud2b8\uac00 \ubcc0\ud654\ud560 \ub54c\uc5d0 \ubcc0\ud654\ud569\ub2c8\ub2e4. EXPLAIN PLAN \uc758 \ucd9c\ub825\uc740 SQL \ubb38\uc758 \uc124\uba85 \ub2e8\uacc4\uc5d0\uc11c\uc758 \uc2e4\ud589 \ubc29\ubc95\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.\uc774 \ubc29\ubc95\uc740 \uc2e4\ud589 \ud658\uacbd\uacfc EXPLAIN PLAN \ud658\uacbd\uacfc\uc758 \ucc28\uc774\uc5d0 \uc758\ud574 SQL \ubb38\uc758 \uc2e4\uc81c\uc758 \uc2e4\ud589 \uacc4\ud68d\uacfc\ub294 \ub2e4\ub978 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.
\n\uc2e4\ud589 \uacc4\ud68d\uc740 \ub2e4\uc74c\uc758 \uc774\uc720\uc5d0 \uc758\ud574 \ub2e4\ub985\ub2c8\ub2e4.<\/p>\n

1. schema\uc758 \uc11c\ub85c \ud2c0\ub9bc
\n——————–
\n1. \uc2e4\ud589\uacfc EXPLAIN PLAN\uc774 \ub2e4\ub978 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc0c1\uc5d0\uc11c \uc77c\uc5b4\ub098\ub294 \uacbd\uc6b0.
\n2. \ubb38\uc7a5\uc744 EXPLAIN \ud558\ub294 \uc720\uc800\uac00 \ubb38\uc7a5\uc744 \uc2e4\ud589\ud558\ub294 \uc720\uc800\uc640 \ub2e4\ub978 \uacbd\uc6b0. 2\uba85\uc758 \uc720\uc838 \uac19\uc740 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc758 \ub2e4\ub978 \uc624\ube0c\uc81d\ud2b8\ub97c \uac00\ub9ac\ud0a4\uace0 \uc788\uc73c\uba74, \ub2e4\ub978 \uc2e4\ud589 \uacc4\ud68d\uc774 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.
\n3. 2 \uac1c\uc758 \uc870\uc791\uac04\uc5d0 schema\uac00 \ubcc0\uacbd\ub418\uc5c8\uc744 \uacbd\uc6b0(\ub9ce\uac8c\ub294 \uc0c9\uc778\uc758 \ubcc0\uacbd).<\/p>\n

2.\ucf54\uc2a4\ud2b8\uc758 \uc11c\ub85c \ud2c0\ub9bc
\n——————
\nschema\uac00 \uac19\uc544\ub3c4 \ucf54\uc2a4\ud2b8\uac00 \ub2e4\ub978 \uacbd\uc6b0\uc5d0 \uc635\ud2f0\ub9c8\uc774\uc838\ub294 \ub2e4\ub978 \uc2e4\ud589 \uacc4\ud68d\uc744 \uc120\ud0dd\ud560 \uac00\ub2a5\uc131\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ucf54\uc2a4\ud2b8\uc5d0 \uc601\ud5a5\uc744 \uc8fc\ub294 \uba87\uac1c\uc758 \uc694\uc778\uc5d0\ub294 \ub2e4\uc74c\uc758 \uac83\uc774 \uc788\uc2b5\ub2c8\ub2e4.
\n1. \ub370\uc774\ud130\ub7c9\uacfc \ud1b5\uacc4
\n2. \ubc14\uc778\ub4dc \ubcc0\uc218\uc758 \ud615\ud0dc
\n3. \ucd08\uae30\ud654 \ud30c\ub77c\ubbf8\ud130(\uae00\ub85c\ubc8c \uc124\uc815 \ub610\ub294 \uc138\uc158\u00b7\ub808\ubca8\ub85c\uc758 \uc124\uc815)<\/p>\n

\ubc30\uc81c\ud589\uc218\uc758 \ucd5c\uc18c\ud654
\nEXPLAIN PLAN \ub97c \uc870\uc0ac\ud558\ub294 \uac83\uc73c\ub85c, \ub2e4\uc74c\uc758 \uacbd\uc6b0\uc758 \ubc30\uc81c\ud589\uc218\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n\uc804\ud45c \uc2a4\uce94
\n\uc120\ud0dd\uc131\uc774 \uc5c6\ub294 \ub808\uc778\uc9c0\u00b7\uc2a4\uce94
\n\uc9c0\uc5f0\ud55c \uc220\uc5b4 \ud544\ud130
\n\uc798\ubabb\ub41c \uacb0\ud569 \uc21c\uc11c
\n\uc9c0\uc5f0\ud55c \ud544\ud130 \ucc98\ub9ac<\/p>\n

\uc608\ub97c \ub4e4\uc5b4, \ub2e4\uc74c\uc758 EXPLAIN PLAN\uc5d0\uc11c\ub294 \ub9c8\uc9c0\ub9c9 \uc2a4\ud15d\uc740 \ub9e4\uc6b0 \uc120\ud0dd\uc131\uc774 \uc5c6\ub294 \ub808\uc778\uc9c0\u00b7\uc2a4\uce94 \uc785\ub2c8\ub2e4.\uc774 \ub808\uc778\uc9c0\u00b7\uc2a4\uce94\uc740 76563 \ud68c \uc2e4\ud589\ub418\uc5b4 11432983 \ud589\uc5d0 \uc561\uc138\uc2a4 \ud574, \uc561\uc138\uc2a4 \ud55c \ud589\uc758 99 \ud37c\uc13c\ud2b8\ub97c \ubc30\uc81c\ud574 76563 \ud589\uc744 \ubcf4\uad00 \uc720\uc9c0\ud569\ub2c8\ub2e4.11432983 \ud589\uc5d0 \uc561\uc138\uc2a4 \ud55c \uacb0\uacfc \ud544\uc694\ud55c \ud589\uc774 76563 \ud589\ubfd0\uc774\ub77c\uace0 \ud310\ubcc4\ub41c \uc774\uc720\uc5d0 \ub300\ud574\uc11c \uc0dd\uac01\ud569\ub2c8\ub2e4.<\/p>\n

\uc608 9-1 EXPLAIN PLAN \ub0b4\uc758 \ubc30\uc81c\ud589\uc218\uc758 \ud655\uc778<\/p>\n

\"EXPLAIN<\/a><\/p>\n

\uc2e4\ud589 \uacc4\ud68d \uc774\uc678\uc758 \uace0\ub824\uc0ac\ud56d
\n——————————————-
\n\uc2e4\ud589 \uacc4\ud68d\uc758 \uc870\uc791\ub9cc\uc73c\ub85c\ub294 \uc798 \uc870\uc815\ub41c \ubb38\uc7a5\uacfc \uc798 \uae30\ub2a5\ud558\uc9c0 \uc54a\ub294 \ubb38\uc7a5\uc744 \uad6c\ubcc4\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc608\ub97c\ub4e4\uc5b4 \ubb38\uc7a5\uc5d0 \uc758\ud55c \uc0c9\uc778\uc758 \uc0ac\uc6a9\uc774 EXPLAIN PLAN \ucd9c\ub825\uc73c\ub85c \ub098\ud0c0\ub0ac\ub2e4\uace0 \ud574\ub3c4, \uadf8 \ubb38\uc7a5\uc774 \ud6a8\uc728\uc801\uc73c\ub85c \uae30\ub2a5\ud55c\ub2e4\ub77c\uace0 \ub2e8\uc815 \ud560\uc218 \uc5c6\ub2e4. \uc778\ub371\uc2a4\ub294 \ub9e4\uc6b0 \ube44\ud6a8\uc728\uc801\uc778 \uacbd\uc6b0\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, \ub2e4\uc74c\uc744 \uc870\uc0ac\ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc0ac\uc6a9\ub418\ub294 \uc0c9\uc778\uc758 \uc5f4
\n\uadf8 \uc0c9\uc778\uc758 \uc120\ud0dd\uc131(\uc561\uc138\uc2a4 \ub418\ub294 \ud45c\uc758 \uc77c\ubd80)<\/p>\n

\ub530\ub77c\uc11c EXPLAIN PLAN \ub85c \uc561\uc138\uc2a4 \uacc4\ud68d\uc744 \ud310\ub2e8\ud574 \ub098\uc911\uc5d0 \ud14c\uc2a4\ud2b8\uc5d0 \uc758\ud574\uc11c \uadf8\uac83\uc774 \ucd5c\uc801\uc758 \uacc4\ud68d\uc778 \uac83\uc744 \ud655\uc778\ud558\ub294 \uac83\uc774 \uac00\uc7a5 \uc88b\uc740 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uacc4\ud68d\uc744 \ud3c9\uac00\ud560 \ub54c\ub294 \ubb38\uc7a5\uc758 \uc815\ud655\ud55c \ub9ac\uc18c\uc2a4 \uc0ac\uc6a9\ub7c9\uc744 \uc870\uc0ac\ud55c\ub2e4. Oracle Trace \ub610\ub294 SQL \ud2b8\ub808\uc774\uc2a4 \uae30\ub2a5\uacfc TKPROF <\/a>\ub97c \uc0ac\uc6a9\ud574 \uac1c\uac1c\uc758 SQL \ubb38\uc758 \ud37c\ud3ec\uba3c\uc2a4\ub97c \uc870\uc0ac\ud574\uc57c \ud55c\ub2e4.<\/p>\n

———————————————-
\n\u25a0 PLAN_TABLE \ucd9c\ub825\ud45c\uc758 \uc791\uc131
\n———————————————-
\nEXPLAIN PLAN \ubb38\uc744 \ubc1c\ud589\ud558\uae30 \uc804\uc5d0 \ucd9c\ub825 \uacb0\uacfc\ub97c \ub123\uc744 \ud14c\uc774\ube14\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. PLAN_TABLE\ub294 EXPLAIN PLAN \ubb38\uc774 \uc2e4\ud589 \uacc4\ud68d\uc5d0 \ub300\ud574 \uae30\uc220\ud558\uace0 \uc788\ub294 \ud589\uc744 \uc0bd\uc785\ud558\ub294 \ub514\ud3f4\ud2b8\uc758 \uc0d8\ud50c \ucd9c\ub825 \ud14c\uc774\ube14 \uc785\ub2c8\ub2e4. SQL \uc2a4\ud06c\ub9bd\ud2b8 UTLXPLAN.SQL\ub97c \uc0ac\uc6a9\ud574 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 schema\ub0b4\uc5d0 PLAN_TABLE \ub97c \uc791\uc131\ud55c\ub2e4. \uc774 \uc2a4\ud06c\ub9bd\ud2b8\uc758 \uc815\ud655\ud55c \uc774\ub984\uacfc \uc704\uce58\ub294, \uc0ac\uc6a9\ud558\ub294 OS\uc5d0 \ub530\ub77c\uc11c \ub2e4\ub985\ub2c8\ub2e4. \uc774 \uc2a4\ud06c\ub9bd\ud2b8\ub294 UNIX \uc0c1\uc5d0\uc11c\ub294 $ORACLE_HOME\/rdbms\/admin \ub514\ub809\ud1a0\ub9ac\uc5d0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

SQL> CONNECT HR\/your_password\r\nSQL> @$ORACLE_HOME\/RDBMS\/ADMIN\/UTLXPLAN.SQL\r\nTable created.\r\n<\/pre>\n
\ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc758 \ubc84\uc83c\uc744 \uac31\uc2e0\ud588\uc744 \uacbd\uc6b0\ub294 \uc5f4\uc774 \ubcc0\uacbd\ub420 \uac00\ub2a5\uc131\uc774 \uc788\uae30 \ub54c\ubb38\uc5d0 PLAN_TABLE \ud14c\uc774\ube14\uc744 \uc0ad\uc81c\ud558\uace0 \uc7ac\uc791\uc131\ud558\ub294 \uac83\uc744 \ucd94\ucc9c\ud569\ub2c8\ub2e4. \ud14c\uc774\ube14\uc744 \uc9c0\uc815\ud558\ub294 \uacbd\uc6b0\ub294 \uc2a4\ud06c\ub9bd\ud2b8\uc758 \uc2e4\ud589\uc774 \uc2e4\ud328\ud558\uac70\ub098 TKPROF\uac00 \uc2e4\ud328\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.
\n\ub2e4\ub978 \uc774\ub984\uc758 \ucd9c\ub825 \ud14c\uc560\ube14\uc774\ud544\uc694\ud55c \uacbd\uc6b0\ub294 PLAN_TABLE\ub97c \uc791\uc131\ud574 RENAME SQL\ubb38\uc73c\ub85c \uadf8 \uc774\ub984\uc744 \ubcc0\uacbd \ud569\ub2c8\ub2e4.<\/p>\n
———————————————-
\n\u25a0 EXPLAIN PLAN \uc758 \uc2e4\ud589
\n———————————————-
\nSQL\ubb38\uc744 EXPLAIN \ud558\ub294 \uacbd\uc6b0\ub294 \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n
EXPLAIN PLAN FOR \r\nSQL_Statement<\/pre>\n
\uc608)<\/p>\n
EXPLAIN PLAN FOR\r\nSELECT last_name FROM employees;\r\n<\/pre>\n
\uacc4\ud68d\uc744 EXPLAIN\ud55c \uac83\uc774 PLAN_TABLE \ud14c\uc774\ube14\uc5d0 \uc0bd\uc785\ub429\ub2c8\ub2e4. PLAN_TABLE \ub85c\ubd80\ud130 \uc2e4\ud589 \uacc4\ud68d\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\uac8c \ub429\ub2c8\ub2e4. \uc774\uac83\uc740 PLAN_TABLE \ub0b4\uc5d0 \ub2e4\ub978 \uacc4\ud68d\uc774 \uc5c6\ub294 \uacbd\uc6b0\ub098 \ub9c8\uc9c0\ub9c9 \ubb38\uc7a5\ub9cc\uc744 \ubcf4\ub294 \uacbd\uc6b0\uc5d0 \ud3b8\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n
EXPLAIN PLAN \ub85c\uc758 \ubb38\uc7a5\uc758 \uc9c0\uc815<\/p>\n
\ubcf5\uc218\uc758 \ubb38\uc7a5\uc774 \uc788\uc744 \ub54c\ub294 \ubb38\uc7a5\uc758 \uc2dd\ubcc4\uc790\ub97c \uc9c0\uc815\ud574 \uadf8 \uc2dd\ubcc4\uc790\ub85c \ud2b9\uc815\uc758 \uc2e4\ud589 \uacc4\ud68d\uc744 \uc2dd\ubcc4\ud560\uc218 \uc788\ub2e4. SET STATEMENT ID\ub97c \uc0ac\uc6a9\ud558\uae30 \uc804\uc5d0 \uadf8 \ubb38\uc7a5\uacfc \uac19\uc740 \uc2dd\ubcc4\uc790\ub97c \uac00\uc9c0\ub294 \uae30\uc874\uc758 \ud589\uc744 \uc0ad\uc81c\ud55c\ub2e4.<\/p>\n
\uc608) STATEMENT ID\ub97c \uc0ac\uc6a9\ud55c EXPLAIN PLAN \uc758 \uc0ac\uc6a9 \ubc29\ubc95<\/p>\n
EXPLAIN PLAN\r\nSET STATEMENT_ID = \\'bad1\\' FOR\r\nSELECT last_name FROM employees;<\/pre>\n
EXPLAIN PLAN\uc5d0\uc11c \ub2e4\ub978 \ud14c\uc774\ube14\uc758 \uc9c0\uc815
\nINTO \uad6c\ub97c \uc9c0\uc815\ud558\uba74 \ub2e4\ub978 \ud14c\uc774\ube14\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc608) INTO \uad6c\ub85c\uc758 EXPLAIN PLAN \uc758 \uc0ac\uc6a9 \ubc29\ubc95<\/p>\n
EXPLAIN PLAN INTO my_plan_table FOR\r\nSELECT last_name FROM employees;\r\n<\/pre>\n
INTO \uad6c\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\ub77c\ub3c4 \ubb38\uc7a5\uc758 \uc2dd\ubcc4\uc790\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc608)<\/p>\n
EXPLAIN PLAN\r\nINTO my_plan_table\r\nSET STATEMENT_ID = \\'bad1\\' FOR\r\nSELECT last_name FROM employees;\r\n<\/pre>\n
———————————–
\n\u25a0 PLAN_TABLE \ucd9c\ub825\uc758 \ud45c\uc2dc
\n———————————–
\n\uacc4\ud68d\uc744 EXPLAIN \ud55c \ud6c4 Oracle\ub85c\ubd80\ud130 \uc81c\uacf5\ub418\ub294 2 \uac1c\uc758 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc0ac\uc6a9\ud574 \ucd5c\uc2e0\uc758 PLAN TABLE \ucd9c\ub825\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4.
\nUTLXPLS.SQL – \uc2dc\ub9ac\uc5bc \ucc98\ub9ac\ub97c \uc704\ud55c PLAN TABLE \ucd9c\ub825\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4.
\nUTLXPLP.SQL – \ud328\ub7ec\ub810 \uc2e4\ud589\uc5f4\uc744 \uac00\uc9c0\ub294 PLAN TABLE \ucd9c\ub825\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4.<\/p>\n
\ubb38\uc7a5\uc758 \uc2dd\ubcc4\uc790\ub97c \uc9c0\uc815\ud588\uc744 \uacbd\uc6b0\ub294 PLAN_TABLE\ub97c \ubb38\uc758\ud558\uae30 \uc704\ud55c \ub3c5\uc790\uc801\uc778 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc4f0\ub294 \uac83\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc5d0 \uc608\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/p>\n
START WITH ID = 0 \ubc0f STATEMENT_ID \ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4.
\nCONNECT BY \uad6c\ub97c \uc0ac\uc6a9\ud574 \ubd80\ubaa8\ub85c\ubd80\ud130 \uc790\uc2dd\uc5d0\uac8c \ud2b8\ub9ac\ub97c \uc774\ub3d9\ud569\ub2c8\ub2e4. \uacb0\ud569 \ud0a4\ub294, STATEMENT_ID = PRIOR STATEMENT_ID \uc640 PARENT_ID = PRIOR ID \uc785\ub2c8\ub2e4. <\/p>\n
\uc720\uc0ac\uc5f4LEVEL(CONNECT BY \uc5d0 \uad00\ub828\uc9c0\uc744 \uc218 \uc788\uace0 \uc788\ub2e4)\ub97c \uc0ac\uc6a9\ud574 \uc790\uc2dd\ub97c \uc778\ub374\ud2b8 \uc12c<\/p>\n
SELECT cardinality \"Rows\",\r\nlpad(' ',level-1)||operation||' '||\r\noptions||' '||object_name \"Plan\"\r\nFROM PLAN_TABLE\r\nCONNECT BY prior id = parent_id\r\nAND prior statement_id = statement_id\r\nSTART WITH id = 0\r\nAND statement_id = 'bad1'\r\nORDER BY id;\r\n\r\nRows    Plan\r\n------- ----------------------------------------\r\nSELECT STATEMENT\r\nTABLE ACCESS FULL EMPLOYEES\r\n<\/pre>\n
Rows\uc5f4\uc758 NULL\uc740 \uc635\ud2f0\ub9c8\uc774\uc838\uac00 \ud14c\uc774\ube14 \ud1b5\uacc4\ub97c \uac00\uc9c0\uace0 \uc788\uc9c0 \uc54a\uc740 \uac83\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \ud14c\uc774\ube14\uc744 ANALYZE \ud558\uba74, \ub2e4\uc74c\uc758 \ub0b4\uc6a9\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n
Rows    Plan\r\n------- ----------------------------------------\r\n16957   SELECT STATEMENT\r\n16957 \u00a0    TABLE ACCESS FULL EMPLOYEES\r\n<\/pre>\n
COST\ub3c4 \uc120\ud0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\uac83\uc740 \uc2e4\ud589 \uacc4\ud68d\uc744 \ube44\uad50\ud558\ub294 \uacbd\uc6b0\ub098 \uc635\ud2f0\ub9c8\uc774\uc838\uac00 \ubcf5\uc218\uc758 \uc548\uc73c\ub85c\ubd80\ud130 \uc788\ub294 \uc2e4\ud589 \uacc4\ud68d\uc744 \uc120\ud0dd\ud55c \uc774\uc720\ub97c \uc774\ud574\ud558\ub294 \uacbd\uc6b0\uc5d0 \ud3b8\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n
\ucc38\uace0 : EXPLAIN PLAN\uc758 \uc0ac\uc6a9\ubc29\ubc95<\/a><\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
  \uc774 \uc7a5\uc5d0\uc11c\ub294 \uc2e4\ud589 \uacc4\ud68d\uc5d0 \ub300\ud55c \uc18c\uac1c, SQL \ucee4\uba58\ub4dc\uc758 EXPLAIN PLAN\ub97c \ud574\uc124\ud558\uace0, \uadf8 \ucd9c\ub825\uc758 \ud574\uc11d \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4. \ub610\ud55c \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ud37c\ud3ec\uba3c\uc2a4 \ud2b9\uc131\uc744 \uc81c\uc5b4\ud558\ub294 OUT LINE \uc744 \uad00\ub9ac\ud558\ub294 \ud504\ub85c\uc2dc\uc800\uc5d0 \ub300\ud574 \uc54c\uc544 \ubd05\ub2c8\ub2e4. \uc774 \uc7a5\uc740 \ub2e4\uc74c\uc758 \uc21c\uc11c\ub85c \uc9c4\ud589\ub429\ub2c8\ub2e4. \u25a0 EXPLAIN PLAN \uc5d0 \ub300\ud574 … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[685],"tags":[925,926,63],"class_list":["post-170","post","type-post","status-publish","format-standard","hentry","category-database-","tag-explain-plan","tag-plan_table","tag-oracle"],"yoast_head":"\nEXPLAIN PLAN\uc758 \uc0ac\uc6a9\ubc29\ubc95 - Apollo89.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/apollo89.com\/wordpress\/?p=170\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EXPLAIN PLAN\uc758 \uc0ac\uc6a9\ubc29\ubc95 - Apollo89.com\" \/>\n<meta property=\"og:description\" content=\"  \uc774 \uc7a5\uc5d0\uc11c\ub294 \uc2e4\ud589 \uacc4\ud68d\uc5d0 \ub300\ud55c \uc18c\uac1c, SQL \ucee4\uba58\ub4dc\uc758 EXPLAIN PLAN\ub97c \ud574\uc124\ud558\uace0, \uadf8 \ucd9c\ub825\uc758 \ud574\uc11d \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4. \ub610\ud55c \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ud37c\ud3ec\uba3c\uc2a4 \ud2b9\uc131\uc744 \uc81c\uc5b4\ud558\ub294 OUT LINE \uc744 \uad00\ub9ac\ud558\ub294 \ud504\ub85c\uc2dc\uc800\uc5d0 \ub300\ud574 \uc54c\uc544 \ubd05\ub2c8\ub2e4. \uc774 \uc7a5\uc740 \ub2e4\uc74c\uc758 \uc21c\uc11c\ub85c \uc9c4\ud589\ub429\ub2c8\ub2e4. \u25a0 EXPLAIN PLAN \uc5d0 \ub300\ud574 … Continue reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/apollo89.com\/wordpress\/?p=170\" \/>\n<meta property=\"og:site_name\" content=\"Apollo89.com\" \/>\n<meta property=\"article:published_time\" content=\"2008-04-21T05:16:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-02-13T03:25:40+00:00\" \/>\n<meta name=\"author\" content=\"apollo89\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"apollo89\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=170#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=170\"},\"author\":{\"name\":\"apollo89\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/93f56825cac3b2f18e5f107995066c82\"},\"headline\":\"EXPLAIN PLAN\uc758 \uc0ac\uc6a9\ubc29\ubc95\",\"datePublished\":\"2008-04-21T05:16:51+00:00\",\"dateModified\":\"2013-02-13T03:25:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=170\"},\"wordCount\":170,\"commentCount\":0,\"keywords\":[\"EXPLAIN PLAN\",\"PLAN_TABLE\",\"\uc624\ub77c\ud074\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=170#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=170\",\"url\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=170\",\"name\":\"EXPLAIN PLAN\uc758 \uc0ac\uc6a9\ubc29\ubc95 - Apollo89.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#website\"},\"datePublished\":\"2008-04-21T05:16:51+00:00\",\"dateModified\":\"2013-02-13T03:25:40+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/93f56825cac3b2f18e5f107995066c82\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=170#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=170\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?p=170#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\ud648\",\"item\":\"https:\\\/\\\/apollo89.com\\\/wordpress\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"EXPLAIN PLAN\uc758 \uc0ac\uc6a9\ubc29\ubc95\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/\",\"name\":\"Apollo89.com\",\"description\":\"\uc544\ud3f4\ub85c\uc528\uc758 \uc7a1\ub2e4\ud55c \uacbd\ud5d8\ub4e4..\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/93f56825cac3b2f18e5f107995066c82\",\"name\":\"apollo89\",\"description\":\"\uc544\ud3f4\ub85c89 \uc785\ub2c8\ub2e4.\",\"url\":\"https:\\\/\\\/apollo89.com\\\/wordpress\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"EXPLAIN PLAN\uc758 \uc0ac\uc6a9\ubc29\ubc95 - Apollo89.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/apollo89.com\/wordpress\/?p=170","og_locale":"ko_KR","og_type":"article","og_title":"EXPLAIN PLAN\uc758 \uc0ac\uc6a9\ubc29\ubc95 - Apollo89.com","og_description":"  \uc774 \uc7a5\uc5d0\uc11c\ub294 \uc2e4\ud589 \uacc4\ud68d\uc5d0 \ub300\ud55c \uc18c\uac1c, SQL \ucee4\uba58\ub4dc\uc758 EXPLAIN PLAN\ub97c \ud574\uc124\ud558\uace0, \uadf8 \ucd9c\ub825\uc758 \ud574\uc11d \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4. \ub610\ud55c \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ud37c\ud3ec\uba3c\uc2a4 \ud2b9\uc131\uc744 \uc81c\uc5b4\ud558\ub294 OUT LINE \uc744 \uad00\ub9ac\ud558\ub294 \ud504\ub85c\uc2dc\uc800\uc5d0 \ub300\ud574 \uc54c\uc544 \ubd05\ub2c8\ub2e4. \uc774 \uc7a5\uc740 \ub2e4\uc74c\uc758 \uc21c\uc11c\ub85c \uc9c4\ud589\ub429\ub2c8\ub2e4. \u25a0 EXPLAIN PLAN \uc5d0 \ub300\ud574 … Continue reading →","og_url":"https:\/\/apollo89.com\/wordpress\/?p=170","og_site_name":"Apollo89.com","article_published_time":"2008-04-21T05:16:51+00:00","article_modified_time":"2013-02-13T03:25:40+00:00","author":"apollo89","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"apollo89","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"2\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/apollo89.com\/wordpress\/?p=170#article","isPartOf":{"@id":"https:\/\/apollo89.com\/wordpress\/?p=170"},"author":{"name":"apollo89","@id":"https:\/\/apollo89.com\/wordpress\/#\/schema\/person\/93f56825cac3b2f18e5f107995066c82"},"headline":"EXPLAIN PLAN\uc758 \uc0ac\uc6a9\ubc29\ubc95","datePublished":"2008-04-21T05:16:51+00:00","dateModified":"2013-02-13T03:25:40+00:00","mainEntityOfPage":{"@id":"https:\/\/apollo89.com\/wordpress\/?p=170"},"wordCount":170,"commentCount":0,"keywords":["EXPLAIN PLAN","PLAN_TABLE","\uc624\ub77c\ud074"],"articleSection":["Database"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/apollo89.com\/wordpress\/?p=170#respond"]}]},{"@type":"WebPage","@id":"https:\/\/apollo89.com\/wordpress\/?p=170","url":"https:\/\/apollo89.com\/wordpress\/?p=170","name":"EXPLAIN PLAN\uc758 \uc0ac\uc6a9\ubc29\ubc95 - Apollo89.com","isPartOf":{"@id":"https:\/\/apollo89.com\/wordpress\/#website"},"datePublished":"2008-04-21T05:16:51+00:00","dateModified":"2013-02-13T03:25:40+00:00","author":{"@id":"https:\/\/apollo89.com\/wordpress\/#\/schema\/person\/93f56825cac3b2f18e5f107995066c82"},"breadcrumb":{"@id":"https:\/\/apollo89.com\/wordpress\/?p=170#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/apollo89.com\/wordpress\/?p=170"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/apollo89.com\/wordpress\/?p=170#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\ud648","item":"https:\/\/apollo89.com\/wordpress"},{"@type":"ListItem","position":2,"name":"EXPLAIN PLAN\uc758 \uc0ac\uc6a9\ubc29\ubc95"}]},{"@type":"WebSite","@id":"https:\/\/apollo89.com\/wordpress\/#website","url":"https:\/\/apollo89.com\/wordpress\/","name":"Apollo89.com","description":"\uc544\ud3f4\ub85c\uc528\uc758 \uc7a1\ub2e4\ud55c \uacbd\ud5d8\ub4e4..","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/apollo89.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/apollo89.com\/wordpress\/#\/schema\/person\/93f56825cac3b2f18e5f107995066c82","name":"apollo89","description":"\uc544\ud3f4\ub85c89 \uc785\ub2c8\ub2e4.","url":"https:\/\/apollo89.com\/wordpress\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=170"}],"version-history":[{"count":0,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/170\/revisions"}],"wp:attachment":[{"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/apollo89.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}