{"batchcomplete":"","continue":{"lecontinue":"20251022061358|336","continue":"-||"},"query":{"logevents":[{"logid":346,"ns":0,"title":"\uc5ed \uc778\ub371\uc2f1(Inverted Index)","pageid":258,"logpage":258,"params":{},"type":"create","action":"create","user":"Oracle","timestamp":"2026-03-13T02:12:43Z","comment":"\uc0c8 \ubb38\uc11c: == \uc5ed \uc778\ub371\uc2f1 (Inverted Index)  == * Oracle Text(Context Index)\uac00 \ubc14\ub85c '\uc5ed \uc0c9\uc778(Inverted Index)' \uc6d0\ub9ac\ub97c \uc774\uc6a9\ud55c \uae30\uc220\uc784. * \uc77c\ubc18\uc801\uc778 B-Tree \uc778\ub371\uc2a4\uac00 \ucc45\uc758 '\ubaa9\ucc28'\ub77c\uba74, \uc5ed \uc778\ub371\uc2a4\ub294 \ucc45 \ub4b7\ubd80\ubd84\uc758 **'\ucc3e\uc544\ubcf4\uae30(\uc0c9\uc778)'**\uc640 \uac19\uc2b5\ub2c8\ub2e4.  * \ud2b9\uc815 \ub2e8\uc5b4\uac00 \uc5b4\ub290 \ud398\uc774\uc9c0(RowID)\uc5d0 \uc788\ub294\uc9c0 \ubbf8\ub9ac \uc9c0\ub3c4\ub85c \uadf8\ub824\ub450\ub294 \ubc29\uc2dd\uc784. ----  === \uc5ed \uc778\ub371\uc2f1(Inverted Index)\uc758 \uc791\ub3d9 \uc6d0\ub9ac === * \uc608\ub97c\ub4e4\uc5b4 5\ucc9c\ub9cc\uac74\uc758 \ub300\uc6a9\ub7c9 \ud14c\uc774\ube14\uc5d0..."},{"logid":345,"ns":0,"title":"\uc55e% LIKE \ud29c\ub2dd","pageid":257,"logpage":257,"params":{},"type":"create","action":"create","user":"Oracle","timestamp":"2026-03-13T02:01:08Z","comment":"\uc0c8 \ubb38\uc11c:  == \uc55e% LIKE \ud29c\ub2dd \ubc29\uc548 ==   {{\uc694\uc810 |\ub0b4\uc6a9= \uc55e% LIKE \ud29c\ub2dd \ubc29\uc548 # B-Tree Index\ub294 LIKE '%~' \uc0ac\uc6a9\uc2dc \uc778\ub371\uc2a4 \uc0ac\uc6a9\ud560\uc218 \uc5c6\uc74c. #: :LIKE '%...' \ud615\ud0dc\uc5d0\uc11c\ub294 \uc0ac\uc2e4\uc0c1 \ubb34\uc6a9\uc9c0\ubb3c # REGEXP_SUBSTR + FUNCTION BASED INDEX\ub97c \uc774\uc6a9\ud55c \uc778\ub371\uc2f1 \ucc98\ub9ac  # Oracle Text (CTXSYS.CONTEXT) \uc774\uc6a9  #: :\ub9e4\uc6b0 \ub192\uc74c\ubcf4\ud1b5\ub300\ub7c9\uc758 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc5d0 \ucd5c\uc801\ud654\ub41c \ud45c\uc900 \ubc29\uc2dd # Parallel Query #: :\ub192\uc74c\ub0ae\uc74c\uc778\ub371\uc2a4 \uc5c6\uc774 \ud558\ub4dc\uc6e8\uc5b4 \uc790\uc6d0\uc73c\ub85c \ud574\uacb0  }}  * \uc131..."},{"logid":344,"ns":0,"title":"\ud29c\ub2dd \ud78c\ud2b8","pageid":256,"logpage":256,"params":{},"type":"create","action":"create","user":"Oracle","timestamp":"2026-01-26T02:05:48Z","comment":"\uc0c8 \ubb38\uc11c: {:\ud29c\ub2dd \ud78c\ud2b8 no merge}"},{"logid":343,"ns":0,"title":"\ud29c\ub2dd \ud78c\ud2b8 no merge","pageid":255,"logpage":255,"params":{},"type":"create","action":"create","user":"Oracle","timestamp":"2026-01-26T02:02:53Z","comment":"\uc0c8 \ubb38\uc11c: == NO_MERGE` \ud78c\ud2b8\ub97c \uc0ac\uc6a9\ud558\ub294 \uc774\uc720 ==   ## NO_MERGE \ud78c\ud2b8\uc758 \uae30\ubcf8 \uac1c\ub150  # Oracle \uc635\ud2f0\ub9c8\uc774\uc800\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \ubdf0 \ubcd1\ud569(View Merging) \uc744 \uc218\ud589\ud568.  # \uc774\ub294 \uc778\ub77c\uc778 \ubdf0\ub098 WITH \uc808\uc758 \ucffc\ub9ac\ub97c \uba54\uc778 \ucffc\ub9ac\uc640 \ud569\uccd0\uc11c \ud558\ub098\uc758 \ucffc\ub9ac \ube14\ub85d\uc73c\ub85c \ub9cc\ub4dc\ub294 \ucd5c\uc801\ud654 \uae30\ubc95.  <source lang=sql> -- \ubcd1\ud569 \uc804 (\ub17c\ub9ac\uc801 \uad6c\uc870) SELECT * FROM (     SELECT employee_id, salary      FROM employees      WHERE department_id = 10 ) v WHERE v.salary > 5000;  --..."},{"logid":342,"ns":0,"title":"\ud30c\ud2f0\uc154\ub2dd","pageid":254,"logpage":254,"params":{},"type":"create","action":"create","user":"Oracle","timestamp":"2026-01-23T06:54:58Z","comment":"\uc0c8 \ubb38\uc11c:  == \ud30c\ud2f0\uc154\ub2dd == === VLDB(Very Large Databases) \uc640 \ud30c\ud2f0\uc154\ub2dd === * \ud30c\ud2f0\uc154\ub2dd\uc740 \ub300\ud615 \ud14c\uc774\ube14\uacfc \uc778\ub371\uc2a4\ub97c \ub354 \uc791\uc740 \uc870\uac01\uc73c\ub85c \ub098\ub204\uc5b4 \uc131\ub2a5, \uad00\ub9ac\uc131, \uac00\uc6a9\uc131\uc744 \ud5a5\uc0c1\uc2dc\ud0b4  * SQL\uc774\ub098 DML \ubcc0\uacbd \uc5c6\uc774 \uc801\uc6a9 \uac00\ub2a5\ud558\uba70, \ud30c\ud2f0\uc158 \ub2e8\uc704\ub85c DDL \uc870\uc791 \uac00\ub2a5  \ufffc * \ud30c\ud2f0\uc154\ub2dd\uc740 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ucf54\ub4dc \uc218\uc815 \uc5c6\uc774 \uc801\uc6a9 \uac00\ub2a5\ud558\uba70, \ud070 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub3c4 \ud6a8\uacfc\uc801\uc73c\ub85c \ucc98\ub9ac \uac00\ub2a5  \ufffc * \ub370\uc774\ud130 \uc218\uba85\uc8fc\uae30 \uad00\ub9ac(ILM)\uc758 \uae30\ubc18..."},{"logid":341,"ns":0,"title":"\uadf8\ub798\ud504DB \uc640 \ubca1\ud130DB","pageid":253,"logpage":253,"params":{},"type":"create","action":"create","user":"Oracle","timestamp":"2025-12-15T05:32:39Z","comment":"\uc0c8 \ubb38\uc11c: == \uadf8\ub798\ud504 DB(Graph Database) \uc640 \ubca1\ud130 DB(Vector Database) ==   {\ud2c0:\uc694\uc57d |\uc81c\ubaa9=* \uadf8\ub798\ud504 DB: ** \u201c\ub204\uac00 \ub204\uad6c\uc640 \uc5b4\ub5bb\uac8c \uc5f0\uacb0\ub418\uc5b4 \uc788\ub294\uac00\u201d \ub97c \ube60\ub974\uac8c \ucc3e\ub294 DB * \ubca1\ud130 DB: ** \u201c\uc774 \ub370\uc774\ud130\uc640 \uac00\uc7a5 \ube44\uc2b7\ud55c \uac83\uc740 \ubb34\uc5c7\uc778\uac00\u201d \ub97c \ucc3e\ub294 DB } \u2e3b  === \ud575\uc2ec \uac1c\ub150 \ube44\uad50 === {| class=\"wikitable\" |+ \ud575\uc2ec \uac1c\ub150 |- ! \uad6c\ubd84\t!! \uadf8\ub798\ud504 DB\t!! \ubca1\ud130 DB |- | \ud575\uc2ec \ubaa9\uc801\t|| \uad00\uacc4 \ud0d0\uc0c9\t|| \uc720\uc0ac\ub3c4 \uac80\uc0c9 |- | \ub370\uc774\ud130 \ud615\ud0dc\t|| \ub178\ub4dc +..."},{"logid":340,"ns":0,"title":"SQL \ud2b8\ub808\uc774\uc2a4 \ubc29\ubc95","pageid":252,"logpage":252,"params":{},"type":"create","action":"create","user":"Dbstudy","timestamp":"2025-11-20T17:07:38Z","comment":"\uc0c8 \ubb38\uc11c: == SQL \ud2b8\ub808\uc774\uc2a4 ==  === SQL \uc138\uc158 \ud2b8\ub808\uc774\uc2a4 \uc218\ud589 ==== <source lang=sql> -- 0.\ud2b8\ub808\uc774\uc2a4 \uc2dd\ubcc4\uc790 \uc9c0\uc815 alter session set tracefile_identifier=\u2019DBSTUDY_TUN_DUMP\u2019; ==> orcl_ora_10024_\"DBSTUDY_TUN_DUMP\".trc \ud615\ud0dc\ub85c \uc800\uc7a5\ub428.  -- 1. sql trace \uc2dc\uc791  ALTER SESSION SET SQL_TRACE = TRUE;  -- 2. event \ub97c level 12 \ub85c \uc124\uc815.   \uc774\ub807\uac8c \uc124\uc815\ud558\uba74, SQL trace \uc815\ubcf4, \uc2e4\ud589\uacc4\ud68d, \ub300\uae30 \uc774\ubca4\ud2b8 \uc815\ubcf4\ub97c \ubcfc \uc218 \uc788\ub2e4.  ALTER SESSION SET events '10046 trace n..."},{"logid":339,"ns":2,"title":"\uc0ac\uc6a9\uc790:\uc81c\ub2c8","pageid":0,"logpage":0,"params":{"userid":11},"type":"newusers","action":"create","user":"\uc81c\ub2c8","timestamp":"2025-11-14T03:55:58Z","comment":""},{"logid":338,"ns":0,"title":"\uce74\ub514\ub110\ub9ac\ud2f0 \uc640 \uc140\ub809\ud2f0\ube44\ud2f0","pageid":251,"logpage":251,"params":{},"type":"create","action":"create","user":"Oracle","timestamp":"2025-10-24T04:00:49Z","comment":"\uc0c8 \ubb38\uc11c:  == Cardinality (\uce74\ub514\ub110\ub9ac\ud2f0) \uc640 Selectivity (\uc120\ud0dd\ub3c4)  {{\ud575\uc2ec |\uc81c\ubaa9= * Cardinality (\uce74\ub514\ub110\ub9ac\ud2f0) ** \ud2b9\uc815 \uc5f0\uc0b0\uc774\ub098 \uc870\uac74\uc5d0\uc11c \ubc18\ud658\ub418\ub294 \uc608\uc0c1 \ud589\uc758 \uac1c\uc218 ** \uc808\ub300\uc801\uc778 \uc218\uce58 (\ud589 \uac1c\uc218) ** \uc2e4\ud589 \uacc4\ud68d\uc758 \u201cRows\u201d \uceec\ub7fc\uc5d0 \ud45c\uc2dc\ub428 *:-------------- * Selectivity (\uc120\ud0dd\ub3c4) ** \uc804\uccb4 \ud589 \uc911\uc5d0\uc11c \uc870\uac74\uc744 \ub9cc\uc871\ud558\ub294 \ud589\uc758 \ube44\uc728 ** \uc0c1\ub300\uc801\uc778 \ube44\uc728 (0 ~ 1 \uc0ac\uc774\uc758 \uac12, \ub610\ub294 0% ~ 100%) ** \uc870\uac74\uc758 \u201c\uc120\ud0dd\uc801\u201d \uc815\ub3c4\ub97c \ub098\ud0c0..."},{"logid":337,"ns":0,"title":"\ud14c\uc2a4\ud2b83","pageid":250,"logpage":250,"params":{},"type":"create","action":"create","user":"Jhwang327","timestamp":"2025-10-22T06:17:31Z","comment":"\uc0c8 \ubb38\uc11c: \uae00\uc4f0\uae30 \ud14c\uc2a4\ud2b81  \uc81c\ubaa91  \uc81c\ubaa92  \uc81c\ubaa93"}]}}