미디어위키 API 결과
이것은 JSON 형식의 HTML 표현입니다. HTML은 디버깅에 적합하지만 응용 프로그램 사용에는 적합하지 않습니다.
출력 형식을 변경하려면 format 매개변수를 지정하십시오. JSON 형식의 비 HTML 표현을 보려면 format=json를 설정하십시오.
{
"batchcomplete": "",
"continue": {
"lecontinue": "20250925053818|328",
"continue": "-||"
},
"query": {
"logevents": [
{
"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"
},
{
"logid": 336,
"ns": 2,
"title": "\uc0ac\uc6a9\uc790:Jhwang327",
"pageid": 0,
"logpage": 0,
"params": {
"userid": 10
},
"type": "newusers",
"action": "create",
"user": "Jhwang327",
"timestamp": "2025-10-22T06:13:58Z",
"comment": ""
},
{
"logid": 335,
"ns": 0,
"title": "Hash join Probe \ub2e8\uacc4 \ucc98\ub9ac\uacfc\uc815",
"pageid": 249,
"logpage": 249,
"params": {},
"type": "create",
"action": "create",
"user": "Oracle",
"timestamp": "2025-10-21T04:05:10Z",
"comment": "\uc0c8 \ubb38\uc11c: == hash join Probe\ub2e8\uacc4 \ucc98\ub9ac \uacfc\uc815 == * \uc9c8\ubb38 : \ud574\uc2dc\uc870\uc778\uc5d0\uc11c Probe \ub2e8\uacc4\uc5d0\uc11c \ud574\uc2dc\ubc14\ud0b7\uc744 \uc0ac\uc6a9 \ud558\ub2c8\uc694? *: ==> \uc544\ub2c8\uc694! Probe \ud14c\uc774\ube14\uc758 \uceec\ub7fc\uc740 \ud574\uc2dc \ubc84\ud0b7\uc5d0 \uc800\uc7a5\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. * \uc608\uc81c <source lang=sql> SELECT e.emp_id, e.name, e.salary, d.dept_name FROM employees e -- \u2190 Build \ud14c\uc774\ube14 (\uc791\uc740 \ud14c\uc774\ube14) JOIN departments d -- \u2190 Probe \ud14c\uc774\ube14 (\ud070 \ud14c\uc774\ube14) ON e.dept_id = d.dept_id </source> === \ud574\uc2dc \ubc84\ud0b7\uc5d0 \uc800\uc7a5..."
},
{
"logid": 334,
"ns": 0,
"title": "\ud574\uc2dc \ubc84\ud0b7\uc758 \uc800\uc7a5\uad6c\uc870",
"pageid": 248,
"logpage": 248,
"params": {},
"type": "create",
"action": "create",
"user": "Dbstudy",
"timestamp": "2025-10-21T01:51:11Z",
"comment": "\uc0c8 \ubb38\uc11c: == Oracle Hash Join\uc758 \ub0b4\ubd80 \uad6c\uc870== * \ud574\uc2dc \ubc84\ud0b7\uc758 \uc800\uc7a5 \uad6c\uc870 === \ud574\uc2dc \ubc84\ud0b7\uc5d0 \uc800\uc7a5\ub418\ub294 \ub0b4\uc6a9 === * \ud574\uc2dc \ubc84\ud0b7\uc5d0\ub294 '''\uc8fc\uc18c \uc815\ubcf4\uac00 \uc544\ub2cc \uc2e4\uc81c \ub370\uc774\ud130 \ud589(row data)''' \uc774 \uc800\uc7a5\ub429\ub2c8\ub2e4. <source lang=python> # \ud574\uc2dc \ud14c\uc774\ube14 \uad6c\uc870: #[\ud574\uc2dc \ubc84\ud0b7 \ubc30\uc5f4] Bucket 0 \u2192 [emp_id=101, name='\uae40\ucca0\uc218', dept_id=10] \u2192 [emp_id=501, name='\uc774\uc601\ud76c', dept_id=10] \u2192 NULL Bucket 1 \u2192 [emp_id=202, name='\ubc15\ubbfc\uc218', dept_id=20] \u2192 NULL Bucket..."
},
{
"logid": 333,
"ns": 0,
"title": "MERGE \uc870\uc778",
"pageid": 202,
"logpage": 202,
"params": {
"curid": 1200,
"previd": 0
},
"type": "patrol",
"action": "patrol",
"user": "Dbstudy",
"timestamp": "2025-10-21T00:35:50Z",
"comment": ""
},
{
"logid": 332,
"ns": 0,
"title": "\uc778\ub371\uc2a4 \ud074\ub7ec\uc2a4\ud130\ub9c1 \ud329\ud130",
"pageid": 247,
"logpage": 247,
"params": {},
"type": "create",
"action": "create",
"user": "Oracle",
"timestamp": "2025-10-02T06:53:52Z",
"comment": "\uc0c8 \ubb38\uc11c: \uc88b\uc740 \uc9c8\ubb38\uc785\ub2c8\ub2e4! \uba85\ud655\ud558\uac8c \uc815\ub9ac\ud574\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. ## \uc815\ub2f5: **\uc778\ub371\uc2a4\uc758 Clustering Factor**\uc785\ub2c8\ub2e4! Clustering Factor\ub294 **\uc778\ub371\uc2a4\uc758 \uc18d\uc131**\uc774\uc9c0, \ud14c\uc774\ube14\uc758 \uc18d\uc131\uc774 \uc544\ub2d9\ub2c8\ub2e4. --- ## \uac1c\ub150 \uc815\ub9ac ### \ud83d\udcca Clustering Factor\ub294 \uc778\ub371\uc2a4\ubcc4\ub85c \uc874\uc7ac ```sql -- Clustering Factor\ub294 DBA_INDEXES \ubdf0\uc5d0 \uc788\uc74c (\ud14c\uc774\ube14 \ubdf0\uac00 \uc544\ub2d8!) SELECT index_name, -- \uc778\ub371\uc2a4 \uc774\ub984 table_name, -- \ucc38\uc870\ud558\ub294 \ud14c\uc774\ube14..."
},
{
"logid": 331,
"ns": 0,
"title": "\ud074\ub7ec\uc2a4\ud130\ub9c1 \ud329\ud130",
"pageid": 246,
"logpage": 246,
"params": {},
"type": "create",
"action": "create",
"user": "Oracle",
"timestamp": "2025-10-02T04:43:04Z",
"comment": "\uc0c8 \ubb38\uc11c: {{SQL|\uc81c\ubaa9=CLUSTERING_FACTOR|\ub0b4\uc6a9=## CLUSTERING_FACTOR\ub780? **\uc778\ub371\uc2a4\uc640 \ud14c\uc774\ube14 \ub370\uc774\ud130\uc758 \ubb3c\ub9ac\uc801 \uc815\ub82c \uc0c1\ud0dc\ub97c \ub098\ud0c0\ub0b4\ub294 \ud1b5\uacc4 \uc815\ubcf4**\uc785\ub2c8\ub2e4. \uc778\ub371\uc2a4 \ud0a4 \uc21c\uc11c\uc640 \ud14c\uc774\ube14 \ube14\ub85d\uc758 \ubb3c\ub9ac\uc801 \ubc30\uce58\uac00 \uc5bc\ub9c8\ub098 \uc77c\uce58\ud558\ub294\uc9c0\ub97c \uce21\uc815\ud569\ub2c8\ub2e4.|\ubcf8\ubb38=## \uac12\uc758 \uc758\ubbf8 ### \ud83d\udcca \ubc94\uc704 - **\ucd5c\uc18c\uac12**: \ud14c\uc774\ube14\uc758 \ube14\ub85d \uc218 (\uc644\ubcbd\ud558\uac8c \uc815\ub82c\ub41c \uacbd\uc6b0) - **\ucd5c\ub300\uac12**: \ud14c\uc774\ube14\uc758 \ud589 \uc218 (\uc644\uc804\ud788 \ubb34\uc791\uc704\ub85c \ubd84\uc0b0\ub41c \uacbd\uc6b0) ### \ud574\uc11d..."
},
{
"logid": 330,
"ns": 0,
"title": "\uc624\ub77c\ud074 \uceec\ub7fc\uc800\uc7a5 \ubc29\uc2dd \uac1c\uc120 (12c \uc5c5\uadf8\ub808\uc774\ub4dc)",
"pageid": 245,
"logpage": 245,
"params": {},
"type": "create",
"action": "create",
"user": "Dbstudy",
"timestamp": "2025-09-29T05:43:46Z",
"comment": "\uc0c8 \ubb38\uc11c: ==\uceec\ub7fc default not null \ubcc0\uacbd\uc2dc \uceec\ub7fc\uc800\uc7a5 \ubc29\uc2dd \uac1c\uc120== {{\ud575\uc2ec |\uc81c\ubaa9= \uc624\ub77c\ud074 12c\uc774\ud6c4 \ubd80\ud130\ub294 not null \uceec\ub7fc \ucd94\uac00\uc2dc \ubb3c\ub9ac\uc801\uc778 \uc800\uc7a5\uc744 \ud558\uc9c0 \uc54a\uc9c0 \uba54\ud130\uc815\ubcf4\ub97c \ucc38\uace0\ud558\ub3c4\ub85d \ubcc0\uacbd\ub418\uc5c8\ub2e4. :: - 12c\ubd80\ud130\ub294 NOT NULL \uc5ec\ubd80\uc640 \uad00\uacc4\uc5c6\uc774 DEFAULT \uac12\uc774 \uc788\ub294 \uceec\ub7fc \ucd94\uac00 \uc2dc \uba54\ud0c0\ub370\uc774\ud130\ub9cc \uc800\uc7a5\ub418\uba70, \uc2e4\uc81c \ub370\uc774\ud130\uac00 UPDATE\ub420 \ub54c \ube44\ub85c\uc18c \ubb3c\ub9ac\uc801\uc73c\ub85c \uc800\uc7a5\ub429\ub2c8\ub2e4. |\ub0b4\uc6a9= \uc624\ub77c\ud074 \uacf5\uc2dd \ub808\ud37c\ub7f0\uc2a4 \ub0b4\uc6a9 \ucc38\uc870 :::#..."
},
{
"logid": 329,
"ns": 0,
"title": "\uceec\ub7fc\uc758 \uc21c\uc11c\uac00 \ubcc0\uacbd\uc2dc ROW\uc758 \ubb3c\ub9ac\uc801 \uad6c\uc870\ubcc0\ud654",
"pageid": 227,
"logpage": 227,
"params": {
"curid": 1435,
"previd": 0
},
"type": "patrol",
"action": "patrol",
"user": "Dbstudy",
"timestamp": "2025-09-25T09:26:12Z",
"comment": ""
}
]
}
}