[{"no":"705","minus":"-1612021263","minus_like_count":"0","parent_post_comment_no":"0","post_no":"505","board_id":"","type":"","is_post_reply":"Y","user_no":"24","user_nickname":"\uc544\ub9c8\uc57c","user_thumb_url":"https:\/\/devsnote.com\/assets\/data\/profile\/24_541965cfbfd703938541f977dc046711.jpg?u=1683209320","user_description":"","title":"[\ub2f5\ubcc0]\uc624\ub77c\ud074 \ub300\ub7c9 insert\uc2dc \uc18d\ub3c4\ud5a5\uc0c1 \ubc29\ubc95\uc774 \uad81\uae08\ud569\ub2c8\ub2e4.","comment":"

\uba3c\uc800 FORALL\uc774 \ub4e4\uc5b4\uac04 PL\/SQL\uc744 \uc791\uc131\ud558\ub294 \ubc29\ubc95\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n

FORALL\uc744 \uc0ac\uc6a9\ud558\uba74 \ud558\ub098\uc529 insert\ud558\ub294 \uac83\ubcf4\ub2e4 \uc18d\ub3c4\uac00 \ube68\ub77c\uc9d1\ub2c8\ub2e4.<\/p>\n\n

\uc544\ub798\ub294 FORALL\uc744 \uc0ac\uc6a9\ud558\ub294 \uc608\uc785\ub2c8\ub2e4.<\/p>\n\n

\nSQL> DECLARE\n  2    TYPE mozi_ins IS TABLE OF MOZI%ROWTYPE INDEX BY BINARY_INTEGER;\n  3    tistory mozi_ins;\n  4  BEGIN\n  5    FOR i IN 1 .. 3 LOOP\n  6      tistory(i).C1 := i;\n  7      tistory(i).C2 := i;\n  8    END LOOP;\n  9  \n 10    FORALL i in 1 .. 3 INSERT INTO MOZI VALUES tistory(i);\n 11    COMMIT;\n 12  END;\n 13  \/\n\nPL\/SQL procedure successfully completed.<\/code><\/pre>\n\n <\/p>\n\n
\ub610 \ub2e4\ub978 \ud301\uc740 insert \ud558\uae30 \uc804\uc5d0 \ud14c\uc774\ube14\uc758 index\ub97c \ubaa8\ub450 drop\ud558\uc5ec \uc9c0\uc6b4 \ub2e4\uc74c insert \ud558\uba74 \uc18d\ub3c4\uac00 \ube68\ub77c\uc9d1\ub2c8\ub2e4.<\/p>\n\n
\ubb3c\ub860 insert\ub97c \ub9c8\uce58\uc2e0 \ud6c4\uc5d0\ub294 \ub2e4\uc2dc index\ub97c \uc0dd\uc131\ud574\uc8fc\uc154\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","rating":"0.0","like_count":"0","mentioned_user_nos":"[]","is_secret":"N","is_deleted":"N","deleted":"","created":"2021-01-31 00:41:03","comment_html":"
\uba3c\uc800 FORALL\uc774 \ub4e4\uc5b4\uac04 PL\/SQL\uc744 \uc791\uc131\ud558\ub294 \ubc29\ubc95\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
FORALL\uc744 \uc0ac\uc6a9\ud558\uba74 \ud558\ub098\uc529 insert\ud558\ub294 \uac83\ubcf4\ub2e4 \uc18d\ub3c4\uac00 \ube68\ub77c\uc9d1\ub2c8\ub2e4.<\/p>\n\n
\uc544\ub798\ub294 FORALL\uc744 \uc0ac\uc6a9\ud558\ub294 \uc608\uc785\ub2c8\ub2e4.<\/p>\n\n
\nSQL> DECLARE\n  2    TYPE mozi_ins IS TABLE OF MOZI%ROWTYPE INDEX BY BINARY_INTEGER;\n  3    tistory mozi_ins;\n  4  BEGIN\n  5    FOR i IN 1 .. 3 LOOP\n  6      tistory(i).C1 := i;\n  7      tistory(i).C2 := i;\n  8    END LOOP;\n  9  \n 10    FORALL i in 1 .. 3 INSERT INTO MOZI VALUES tistory(i);\n 11    COMMIT;\n 12  END;\n 13  \/\n\nPL\/SQL procedure successfully completed.<\/code><\/pre>\n\n <\/p>\n\n
\ub610 \ub2e4\ub978 \ud301\uc740 insert \ud558\uae30 \uc804\uc5d0 \ud14c\uc774\ube14\uc758 index\ub97c \ubaa8\ub450 drop\ud558\uc5ec \uc9c0\uc6b4 \ub2e4\uc74c insert \ud558\uba74 \uc18d\ub3c4\uac00 \ube68\ub77c\uc9d1\ub2c8\ub2e4.<\/p>\n\n
\ubb3c\ub860 insert\ub97c \ub9c8\uce58\uc2e0 \ud6c4\uc5d0\ub294 \ub2e4\uc2dc index\ub97c \uc0dd\uc131\ud574\uc8fc\uc154\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","summary":"\uba3c\uc800 FORALL\uc774 \ub4e4\uc5b4\uac04 PL\/SQL\uc744 \uc791\uc131\ud558\ub294 \ubc29\ubc95\uc774 \uc788\uc2b5\ub2c8\ub2e4.\n\nFORALL\uc744 \uc0ac\uc6a9\ud558\uba74 \ud558\ub098\uc529 insert\ud558\ub294 \uac83\ubcf4\ub2e4 \uc18d\ub3c4\uac00 \ube68\ub77c\uc9d1\ub2c8\ub2e4.\n\n\uc544\ub798\ub294 FORALL\uc744 \uc0ac\uc6a9\ud558\ub294 \uc608\uc785\ub2c8\ub2e4.\n\n\nSQL> DECLARE\n  2    TYPE mozi_ins IS TABLE OF MOZI%ROWTYPE INDEX BY BINARY_INTEGER;\n  3    ..."}]

#DML

질문오라클 대량 insert시 속도향상 방법이 궁금합니다.