{"id":2462,"date":"2018-01-27T23:14:47","date_gmt":"2018-01-27T14:14:47","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2462"},"modified":"2020-01-21T16:20:56","modified_gmt":"2020-01-21T07:20:56","slug":"db-admin-%ed%86%b5%ea%b3%84-%ec%a0%95%eb%b3%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ea%b0%b1%ec%8b%a0-%ec%9e%91%ec%97%85-%ec%9d%b4%ed%9b%84-%ec%9e%a5%ec%95%a0-%eb%b0%9c%ec%83%9d","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2462","title":{"rendered":"[DB Admin] \ud1b5\uacc4 \uc815\ubcf4 \ub370\uc774\ud130 \uac31\uc2e0 \uc791\uc5c5 \uc774\ud6c4 \uc7a5\uc560 \ubc1c\uc0dd"},"content":{"rendered":"<p>\uc624\ub77c\ud074DB \ub0b4\uc5d0 \ud14c\uc774\ube14\uc758 \uc815\ubcf4. \ub370\uc774\ud0c0\uc758 \uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \uac83\uc774 \ud1b5\uacc4 \uc815\ubcf4\ub77c\uace0 \ud569\ub2c8\ub2e4. \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0\uc740 DBA\ub4e4\uc774 \ub9ce\uc774 \ud558\ub294 \uc791\uc5c5\uc785\ub2c8\ub2e4. \uc774 \uc815\ubcf4\uac00 \uac31\uc2e0 \ub418\uc5c8\uc744 \ub54c \ubc1c\uc0dd \ud560 \uc218 \uc788\ub294 \uc7a5\uc560\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uace0 \ub300\uccb4 \ubc29\ubc95\uc774 \uc5b4\ub5bb\uac8c \ub418\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud14c\uc2a4\ud2b8\uc6a9 \ud14c\uc774\ube14\uacfc \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image00210.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image002[10]\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image00210_thumb.jpg?resize=640%2C247\" alt=\"clip_image002[10]\" width=\"640\" height=\"247\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;\ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14,\uc778\ub371\uc2a4 \uc0dd\uc131 \ud6c4 \ud1b5\uacc4 \uc815\ubcf4 \uc0dd\uc131&gt;<\/p>\n<p>\ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0 \uc2dc \ubc1c\uc0dd \ud560 \uc218 \uc788\ub294 SQL \uc131\ub2a5 \uc800\ud558\uc758 \ud14c\uc2a4\ud2b8\ub97c \uc704\ud55c \ud14c\uc774\ube14\uacfc \uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c\uc740 \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc758 SQL\uc744 \ud14c\uc2a4\ud2b8 \ud558\uaca0\uc2b5\ub2c8\ub2e4.<b><\/b><\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image004-2.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image004\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image004_thumb-2.jpg?resize=640%2C173\" alt=\"clip_image004\" width=\"640\" height=\"173\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;\uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc774 \uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 SQL&gt;<\/p>\n<p>\uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 SQL \uc785\ub2c8\ub2e4. 0.02\ucd08\uac00 \uac78\ub9ac\uace0 \uc788\uc2b5\ub2c8\ub2e4. \ud2b9\uc815 \uc2dc\uac04\uc5d0 \uc0dd\uc131\ub41c \ub370\uc774\ud0c0\uc758 NOT NULL \uac12\uc758 \uac74\uc218\ub97c \ud655\uc778\ud558\ub294 \ucffc\ub9ac \uc785\ub2c8\ub2e4.<\/p>\n<p>\ud574\ub2f9 \ucffc\ub9ac\uc758 \uc2e4\ud589 \ud50c\ub79c\uc744 \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image006.jpg\"><img loading=\"lazy\" class=\"\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image006\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image006_thumb.jpg?resize=640%2C443\" alt=\"clip_image006\" width=\"640\" height=\"443\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;\uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 SQL\uc758 \uc2e4\ud589 PLAN&gt;<\/p>\n<p>SQL PLAN\uc758 \uc21c\uc11c\ub97c \ubcf4\uba74 REGDATE \uceec\ub7fc\uc5d0 \uc0dd\uc131\ud55c \uc778\ub371\uc2a4\uc778 STAT_TEST_N2\ub97c \uac00\uc7a5 \uba3c\uc800 Range Scan \ud558\ub294 Plan\uc73c\ub85c \uc218\ud589 \ub418\uba70 1\uac74\uc758 Rows\ub97c \ub9cc\ub4e4\uae30 \uc704\ud574 \uc77d\ub294 \ud69f\uc218\ub3c4 \ubb3c\ub9ac\uc801\uc778 \ub514\uc2a4\ud06c \ube14\ub85d \uc811\uadfc \ud69f\uc218 3\ubc88 \uacfc \ubcc0\uacbd\ub41c \ubc84\ud37c \ube14\ub85d \uc218 7\ubc88\uc73c\ub85c \ub9e4\uc6b0 \uc591\ud638\ud558\uace0 \uc88b\uc740 SQL \ub85c \ud480\ub9ac\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774 DB\uc5d0\ub294 Batch \ud504\ub85c\uadf8\ub7a8\uc774 \uc218\ud589\ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ubc30\uce58\uc758 \uc21c\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image008.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image008\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image008_thumb.jpg?resize=640%2C303\" alt=\"clip_image008\" width=\"640\" height=\"303\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;\ud14c\uc2a4\ud2b8 \ubc30\uce58 \ud504\ub85c\uadf8\ub7a8&gt;<\/p>\n<p>\ubc30\uce58 \ud504\ub85c\uadf8\ub7a8\uc740 \ub9e4\uc77c STAT_TEST \ud14c\uc774\ube14\uc744 \ubc31\uc5c5 \ubc1b\uace0 BIRTH \uceec\ub7fc\uc744 NULL\ub85c \uce58\ud658 \ud6c4 \ud504\ub85c\uadf8\ub7a8\uc744 \ub3cc\ub9ac\uace0 \uc885\ub8cc \ub418\uba74 STAT_TEST \ud14c\uc774\ube14\uc744 \uc6d0\ubcf5 \uc2dc\ud0a4\ub294 \uc21c\uc11c\uc758 \ud504\ub85c\uadf8\ub7a8 \uc785\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc81c \uc774 \ubc30\uce58 \ud504\ub85c\uadf8\ub7a8\uc744 \uc2e4\ud589 \uc2dc\ud0b5\ub2c8\ub2e4.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image010.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image010\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image010_thumb.jpg?resize=640%2C189\" alt=\"clip_image010\" width=\"640\" height=\"189\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;\ud14c\uc2a4\ud2b8 \ubc30\uce58 \ud504\ub85c\uadf8\ub7a8 \uc2e4\ud589 \uc911\uac04 \ub2e8\uacc4&gt;<\/p>\n<p>\ubc30\uce58 \ud504\ub85c\uadf8\ub7a8\uc744 \uc2e4\ud589 \uc2dc\ud0a4\ub294 \ub3c4\uc911\uc5d0 \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0 \uc791\uc5c5\uc744 \ud569\ub2c8\ub2e4.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image012.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image012\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image012_thumb.jpg?resize=640%2C110\" alt=\"clip_image012\" width=\"640\" height=\"110\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;\ud14c\uc2a4\ud2b8 \ubc30\uce58 \ud504\ub85c\uadf8\ub7a8 \uc2e4\ud589 \ub3c4\uc911 \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0&gt;<\/p>\n<p>BIRTH \uceec\ub7fc\uc774 Null\ub85c \uce58\ud658\uc774 \uc644\ub8cc \ub41c \ub2e4\uc74c\uc5d0 \uc544\ub798\uc758 \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0 \uc791\uc5c5\uc774 \uc218\ud589 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0\uc744 On-line \uc911\uc5d0 \ub2e4\ub7c9\uc758 \ub370\uc774\ud130\uac00 \ubcc0\uacbd \ub418\ub294 \ub3c4\uc911\uc5d0 \uac31\uc2e0 \ud55c\ub2e4\uace0 \ubcf4\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<p>\uadf8 \uc774\ud6c4 \ubc30\uce58 \ud504\ub85c\uadf8\ub7a8\uc740 \uc218\ud589\uc774 \ub05d\uae4c\uc9c0 \uc644\ub8cc \ub418\uc5c8\uace0, \ub370\uc774\ud130\ub294 \uc6d0\ubcf5 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image014.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image014\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image014_thumb.jpg?resize=640%2C409\" alt=\"clip_image014\" width=\"640\" height=\"409\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;\ud14c\uc2a4\ud2b8 \ubc30\uce58 \ud504\ub85c\uadf8\ub7a8 \uc2e4\ud589 \uc644\ub8cc&gt;<\/p>\n<p>BIRTH \uceec\ub7fc\uc774 Null\ub85c \uce58\ud658\uc774 \uc644\ub8cc \ub41c \ub2e4\uc74c\uc5d0 \uc544\ub798\uc758 \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0 \uc791\uc5c5\uc774 \uc218\ud589 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0\uc744 On-line \uc911\uc5d0 \ub2e4\ub7c9\uc758 \ub370\uc774\ud130\uac00 \ubcc0\uacbd \ub418\ub294 \ub3c4\uc911\uc5d0 \uac31\uc2e0 \ud55c\ub2e4\uace0 \ubcf4\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<p>\uadf8 \uc774\ud6c4 \ubc30\uce58 \ud504\ub85c\uadf8\ub7a8\uc740 \uc218\ud589\uc774 \ub05d\uae4c\uc9c0 \uc644\ub8cc \ub418\uc5c8\uace0, \ub370\uc774\ud130\ub294 \uc6d0\ubcf5 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc81c \ubc30\uce58 \ud504\ub85c\uadf8\ub7a8 \ud14c\uc2a4\ud2b8 \uc774\uc804\uc5d0 \uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 \ucffc\ub9ac\ub97c \uc218\ud589 \uc2dc\ucf1c \ubd05\ub2c8\ub2e4.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image016.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image016\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image016_thumb.jpg?resize=640%2C215\" alt=\"clip_image016\" width=\"640\" height=\"215\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;\uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 SQL\ubb38 \uc7ac \uc2e4\ud589&gt;<\/p>\n<p><span style=\"color: #ff0000;\"><b>0.02<\/b><b>\ucd08 \uc218\ud589 \ub418\uc5c8\ub358 SQL \uc774 9\ubd84 \uac00\ub7c9 \uc218\ud589 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub611 \uac19\uc740 SQL\uc758 \uc218\ud589\uc2dc\uac04\uc774 \uc218 \ubc31\ubc30 \ub290\ub824\uc84c\uc2b5\ub2c8\ub2e4. <\/b><\/span><\/p>\n<p>\uc11c\ube44\uc2a4\uac00 \ub290\ub824\uc9c4 \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud55c \uc0c1\ud669 \uc785\ub2c8\ub2e4. \uc65c \uac19\uc740 SQL \uc774 \ub290\ub824\uc9c4 \uac78\uae4c\uc694? PLAN\uc744 \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<b><\/b><\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image018-1.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image018\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image018_thumb-1.jpg?resize=640%2C446\" alt=\"clip_image018\" width=\"640\" height=\"446\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;\uac11\uc790\uae30 \ub290\ub824\uc9c4 \ub3d9\uc77c SQL\ubb38\uc758 \uc218\ud589 PLAN&gt;<\/p>\n<p>SQL PLAN\uc758 \uc21c\uc11c\uac00 REGDATE \uceec\ub7fc\uc5d0 \uc0dd\uc131\ud55c \uc778\ub371\uc2a4\uc778 STAT_TEST_N2\ub97c \uac00\uc7a5 \uba3c\uc800 Range Scan \ud588\ub358 Plan\uc774 \ubc14\ub00c\uc5c8\uc2b5\ub2c8\ub2e4. BIRTH\uceec\ub7fc\uc5d0 \uc0dd\uc131\ub41c \uc778\ub371\uc2a4 STAT_TEST_N1\ub97c \uac00\uc7a5 \uba3c\uc800 Full Scan \ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 1\uac74\uc758 Rows\ub97c \ub9cc\ub4e4\uae30 \uc704\ud574 \uc77d\ub294 \ud69f\uc218\ub3c4 \ubb3c\ub9ac\uc801\uc778 \ub514\uc2a4\ud06c \ube14\ub85d \uc811\uadfc \ud69f\uc218 3\ubc88 \uacfc \ubcc0\uacbd\ub41c \ubc84\ud37c \ube14\ub85d \uc218 7\ubc88\uc73c\ub85c \ub9e4\uc6b0 \uc591\ud638\ud558\uace0 \uc88b\uc558\ub358 SQL\uc774 1\uac74\uc758 Rows\ub97c \ub9cc\ub4e4\uae30 \uc704\ud574 \uc77d\ub294 \ud69f\uc218\ub3c4 \ubb3c\ub9ac\uc801\uc778 \ub514\uc2a4\ud06c \ube14\ub85d \uc811\uadfc \ud69f\uc218 495\ub9cc\ubc88 \uacfc \ubcc0\uacbd\ub41c \ubc84\ud37c \ube14\ub85d \uc218 568\ub9cc\uac74\uc744 \uc77d\uc5b4\uc57c\ub9cc \ud558\ub294 \uc545\uc131 SQL\ub85c \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc5b4\ub9c8\uc5b4\ub9c8\ud55c \ucc28\uc774\ub97c \ubcf4\uc774\uba70 \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc65c \uc774\ub7f0 \ud604\uc0c1\uc774 \ubc1c\uc0dd\ud558\uc600\ub294\uc9c0 \ud1b5\uacc4 \uc815\ubcf4\uc758 \ub370\uc774\ud130\ub97c \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<b><\/b><\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image020-2.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image020\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image020_thumb-2.jpg?resize=640%2C181\" alt=\"clip_image020\" width=\"640\" height=\"181\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;\ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14\uc758 \ud1b5\uacc4 \uc815\ubcf4 \uac12 \uc870\ud68c&gt;<\/p>\n<p>BIRTH \uac12\uc758 NULL \ud1b5\uacc4 \uc815\ubcf4 \uac12\uc774 \ub192\uc544\uc84c\uc2b5\ub2c8\ub2e4. \uc989 \ubc30\uce58 \ud504\ub85c\uadf8\ub7a8 \ub3c4\uc911\uc5d0 NULL \ub370\uc774\ud130\ub85c \uce58\ud658\ub41c \ud6c4 \ud1b5\uacc4 \uc815\ubcf4\uac00 \uc218\uc9d1\ub418\uc5b4 \ud604\uc7ac \ub370\uc774\ud130 \uac12\uacfc \ub2e4\ub978 \uc218\uce58\ub97c \ubcf4\uc774\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc65c \uc635\ud2f0\ub9c8\uc774\uc800\ub294 \uc774\ub7f0 Plan\uc744 \ub9cc\ub4e4\uc5c8\ub294\uc9c0 \ud1b5\uacc4 \uc815\ubcf4 \ub370\uc774\ud130 \uac12\uacfc SQL\uc744 \ubcf4\uba74 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uadf8\uac74 \ubc14\ub85c \u2018BIRTH IS NOT NULL\u2019 \uc870\uac74 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uc704\uc5d0 \ubc30\uce58 \ud504\ub85c\uadf8\ub7a8 \uc218\ud589 \uc911\uac04\uc5d0 BIRTH \uceec\ub7fc\uc758 \uac12\uc774 \ubaa8\ub450 NULL \ubcc0\uacbd \ub41c \ud6c4 \uac12\uc744 \ub123\uace0 \ud1b5\uacc4 \uc815\ubcf4\ub97c \uac31\uc2e0 \ud55c \uac83\uc744 \uae30\uc5b5 \ud558\uc2e4 \uac81\ub2c8\ub2e4.<\/p>\n<p>\uc635\ud2f0\ub9c8\uc774\uc800 \ub610\ud55c \uc704\uc758 SQL\uc744 \uac00\uc9c0\uace0 Plan\uc744 \ub9cc\ub4e4 \ub54c \u2018BIRTH IS NOT NULL\u2019 \uc774 \uc870\uac74\uc744 \uac00\uc9c0\uace0 \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc0b4\ud3b4\ubcf4\uc558\uace0 \uc0b4\ud3b4\ubcf4\ub2c8 <u>\u2018BIRTH\u2019 \uceec\ub7fc\uc5d0 \uac12\uc774 \ubaa8\ub450 NULL \uc774\ub2e4<\/u> \ub294 \uac83\uc73c\ub85c \ud655\uc778 \ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image022-2.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image022\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image022_thumb-2.jpg?resize=640%2C93\" alt=\"clip_image022\" width=\"640\" height=\"93\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt; \uc635\ud2f0\ub9c8\uc774\uc800\uc758 \uc608\uc0c1 \uac74\uc218\uc640 \uc2e4\uc81c \uac74\uc218\uac00 \ud070 \ucc28\uc774&gt;<\/p>\n<p>\uadf8\ub807\uae30 \ub54c\ubb38\uc5d0 \uc635\ud2f0\ub9c8\uc774\uc800\ub294 INDEX FULL SCAN\uc744 \ud558\uc5ec 0\uac74\uc744 \uc561\uc138\uc2a4 \ud558\ub294 \uac83\uc774 \ucd5c\uc801\uc774\ubbc0\ub85c \ud310\ub2e8\ud558\uc600\uace0 1\uac74\uc744 \uc561\uc138\uc2a4 \ud55c \ub4a4 FROM\uc808\uc758 STAT_TEST \uc5d0 ACCESS \ud558\ub294 \uac83\ubcf4\ub2e4 \ub354 \ub0ab\ub2e4\uace0 \ud310\ub2e8\uc744 \ud55c \uac83\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc774\ucc98\ub7fc \uc635\ud2f0\ub9c8\uc774\uc800\ub294 \ud1b5\uacc4 \uc815\ubcf4\ub97c \ubc14\ud0d5\uc73c\ub85c \uc2e4\ud589\uacc4\ud68d\uc744 \ub9cc\ub4e0\ub2e4\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/p>\n<p>\ud558\uc9c0\ub9cc \ubc30\uce58 \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc \ud6c4 BIRTH \uceec\ub7fc\uc758 \ub370\uc774\ud130\ub294 NULL\uc5d0\uc11c \uc6d0\ubcf5 \ub418\uc5c8\uae30 \ub54c\ubb38\uc5d0 \uc815\ud655\ud788 \ub9e4\uce6d\ub418\ub294 \ud1b5\uacc4 \uc815\ubcf4 \uac12\uc740 \uc544\ub2c8\uc5b4\uc11c \uc608\uc0c1 \uac74\uc218\uc640 \uc2e4\uc81c \uac74\uc218\ub294 \ucc28\uc774\ub97c \ubcf4\uc774\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uadf8\ub7fc \uc774\ub807\uac8c \ud1b5\uacc4 \uc815\ubcf4\ub97c \uac31\uc2e0 \ud558\uace0 <b>\uc5b4\ud50c\ub9ac\ucf00\uc774\uc158\uc774 \uac11\uc790\uae30 \ub290\ub824\uc9c0\ub294 \uc0c1\ud669\uc5d0\uc11c \ub300\ucc98 \ubc29\ubc95<\/b>\uc740 \uc5b4\ub5bb\uac8c \ub420\uae4c\uc694? \uc9c0\uae08\ubd80\ud130 \uc54c\uc544 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image024.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image024\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image024_thumb.jpg?resize=640%2C112\" alt=\"clip_image024\" width=\"640\" height=\"112\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt; \ud14c\uc774\ube14\uc758 \ud1b5\uacc4 \uc815\ubcf4 \uc0dd\uc131 \ud655\uc778&gt;<\/p>\n<p>\ud1b5\uacc4 \uc815\ubcf4\uc758 \uac31\uc2e0 \uc774\ub825\uc744 \uc870\ud68c \ud569\ub2c8\ub2e4. \uc5b4\ub290 \uc2dc\uac04\uc5d0 \ud1b5\uacc4 \uc815\ubcf4\uac00 \uac31\uc2e0 \ub418\uc5c8\ub294\uc9c0 \ud655\uc778 \ud558\uace0 \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc6d0\ubcf5 \uc2dc\ud0ac \uc2dc\uc810\uc744 \uacb0\uc815 \ud569\ub2c8\ub2e4.<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image026.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image026\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image026_thumb.jpg?resize=640%2C332\" alt=\"clip_image026\" width=\"640\" height=\"332\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;\ud1b5\uacc4 \uc815\ubcf4 \uc6d0\ubcf5 \ud6c4 \ud1b5\uacc4 \uc815\ubcf4 \uc6d0\ubcf5 \ud655\uc778&gt;<\/p>\n<p><b>DBMS_STATS <\/b><b>\ud328\ud0a4\uc9c0 \ub0b4\uc5d0 RESTORE_TABLE_STATS \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud558\uc5ec \ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ud1b5\uacc4 \uc815\ubcf4\ub97c \uc6d0\ubcf5<\/b> \uc2dc\ud0b5\ub2c8\ub2e4. \uc6d0\ubcf5 \uc2dc\ud0a8 \uc774\ud6c4 \ud574\ub2f9 \ud14c\uc774\ube14\uc758 \ud1b5\uacc4 \uc815\ubcf4 \uc6d0\ubcf5\uc744 \ud655\uc778\ud558\uace0, \ubb38\uc81c\uac00 \ub418\uc5c8\ub358 \uceec\ub7fc\uc758 \ud1b5\uacc4 \uc815\ubcf4 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc81c \ubb38\uc81c\uac00 \ub418\uc5c8\ub358 \ub290\ub824 \uc84c\ub358 SQL\ubb38\uc744 \uc218\ud589\ud574 \ubd05\ub2c8\ub2e4.<b><\/b><\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image028.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image028\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image028_thumb.jpg?resize=640%2C205\" alt=\"clip_image028\" width=\"640\" height=\"205\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;\ub290\ub824 \uc84c\ub358 SQL \uc218\ud589&gt;<\/p>\n<p>9\ubd84 \uc815\ub3c4 \uac78\ub837\ub358 SQL\ubb38\uc774 0.05\ucd08\ub85c \uc218\ud589 \uc2dc\uac04\uc774 \ub2e4\uc2dc \uc88b\uc544\uc84c\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc81c \ud574\ub2f9 SQL\uc758 SQL \uc218\ud589 PLAN\ub3c4 \ud655\uc778\ud574 \ubd05\ub2c8\ub2e4.<b><\/b><\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image030.jpg\"><img loading=\"lazy\" style=\"margin: 0px 0px 18px; display: inline; background-image: none;\" title=\"clip_image030\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2018\/01\/clip_image030_thumb.jpg?resize=640%2C475\" alt=\"clip_image030\" width=\"640\" height=\"475\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&lt;SQL PLAN \ud655\uc778&gt;<\/p>\n<p>SQL PLAN\uc758 \uc21c\uc11c\ub97c \ubcf4\uba74 REGDATE \uceec\ub7fc\uc5d0 \uc0dd\uc131\ud55c \uc778\ub371\uc2a4\uc778 STAT_TEST_N2\ub97c \uac00\uc7a5 \uba3c\uc800 Range Scan \ud558\ub294 Plan\uc73c\ub85c \uc218\ud589 \ub418\uba70 1\uac74\uc758 Rows\ub97c \ub9cc\ub4e4\uae30 \uc704\ud574 \uc77d\ub294 \ud69f\uc218\ub3c4 \ubb3c\ub9ac\uc801\uc778 \ub514\uc2a4\ud06c \ube14\ub85d \uc811\uadfc \ud69f\uc218 4\ubc88 \uacfc \ubcc0\uacbd\ub41c \ubc84\ud37c \ube14\ub85d \uc218 7\ubc88\uc73c\ub85c \ub9e4\uc6b0 \uc591\ud638\ud558\uace0 \uc88b\uc740 SQL \ub85c \ub2e4\uc2dc \uc218\ud589\ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc9c0\uae08\uae4c\uc9c0 \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0\uc73c\ub85c \uc778\ud55c \uc11c\ube44\uc2a4 \uc751\ub2f5\uc2dc\uac04 \uc800\ud558 \uc7a5\uc560\uc5d0 \ub300\ud574\uc11c \uc54c\uc544 \ubcf4\uc558\uc2b5\ub2c8\ub2e4. \ubcf8 \uc7a5\uc758 \ud575\uc2ec\uc740 \ub370\uc774\ud130\ub370 \ud1b5\uacc4\uc815\ubcf4 \uac12\uc774 \ub2e4\ub97c \uacbd\uc6b0 \ubb38\uc81c\uac00 \ub420 \uc218 \uc788\ub294 \uc810\uc744 \ud14c\uc2a4\ud2b8\ub97c \ud1b5\ud574 \uc54c\uc544 \ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0\uc740 SQL PLAN\uc758 95%\uc758 \uc131\ub2a5 \ud6a8\uacfc \uc7a5\uc810\uacfc 5%\uc758 \uc131\ub2a5 \uc800\ud558 Risk\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4\uace0 \uc54c\ub824\uc838 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub530\ub77c\uc11c \uc800\uc790 \ub610\ud55c \ud1b5\uacc4 \uc815\ubcf4\ub294 DB\ub0b4\uc758 \ub370\uc774\ud130\uc640 \ub9de\ub3c4\ub85d \uac31\uc2e0\uc744 \ucd94\ucc9c\ud569\ub2c8\ub2e4.<\/p>\n<p><a name=\"_GoBack\"><\/a><b>TIP. <\/b><b>\uac00\uc7a5 \ucd94\ucc9c\ud558\ub294 \uc548\uc804\ud55c \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0 \ubc29\ubc95\uc740 \ub370\uc774\ud130 \ubcc0\uacbd\uc774 \uc5c6\uc744 \ub54c \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0\uc744 \ud558\uace0 \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0 \ud6c4 DBMS \ubaa8\ub2c8\ud130\ub9c1 \/ \uc11c\ube44\uc2a4 \ubaa8\ub2c8\ud130\ub9c1 \/ \ud1b5\uacc4 \uc815\ubcf4 \uc6d0\ubcf5 \uc900\ube44 \ub4f1 \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0\uc5d0 \ub530\ub978 SQL PLAN \ubcc0\uacbd\uc73c\ub85c \uc778\ud55c \uc5b4\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ube44\uc2a4\uc758 \uc131\ub2a5 \uc800\ud558 RISK\uc5d0 \ub300\ube44\ub97c \ud558\ub294 \ubc29\ubc95\uc744 \uad8c\ud569\ub2c8\ub2e4.<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc624\ub77c\ud074DB \ub0b4\uc5d0 \ud14c\uc774\ube14\uc758 \uc815\ubcf4. \ub370\uc774\ud0c0\uc758 \uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \uac83\uc774 \ud1b5\uacc4 \uc815\ubcf4\ub77c\uace0 \ud569\ub2c8\ub2e4. \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0\uc740 DBA\ub4e4\uc774 \ub9ce\uc774 \ud558\ub294 \uc791\uc5c5\uc785\ub2c8\ub2e4. \uc774 \uc815\ubcf4\uac00 \uac31\uc2e0 \ub418\uc5c8\uc744 \ub54c \ubc1c\uc0dd \ud560 \uc218 \uc788\ub294 \uc7a5\uc560\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uace0 \ub300\uccb4 \ubc29\ubc95\uc774 \uc5b4\ub5bb\uac8c \ub418\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud14c\uc2a4\ud2b8\uc6a9 \ud14c\uc774\ube14\uacfc \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. &lt;\ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14,\uc778\ub371\uc2a4 \uc0dd\uc131 \ud6c4 \ud1b5\uacc4 \uc815\ubcf4 \uc0dd\uc131&gt; \ud1b5\uacc4 \uc815\ubcf4 \uac31\uc2e0 \uc2dc \ubc1c\uc0dd \ud560 \uc218 \uc788\ub294 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2410,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[832,162,833],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/databaetail.jpg?fit=905%2C480","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2462"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2462"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2462\/revisions"}],"predecessor-version":[{"id":2465,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2462\/revisions\/2465"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2410"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2462"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}