質問編集履歴
2
内容の追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -7,3 +7,67 @@
|
|
|
7
7
|
というのがわからないです。教えていただけないでしょうか。
|
|
8
8
|
|
|
9
9
|
SQLのチューニングを初めて行うのでいまいちやり方がわかりません。
|
|
10
|
+
|
|
11
|
+
|
|
12
|
+
|
|
13
|
+
```lang-＜ここに言語を入力＞
|
|
14
|
+
|
|
15
|
+
------------------------------------------------------------------------------------------------
|
|
16
|
+
|
|
17
|
+
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
|
|
18
|
+
|
|
19
|
+
------------------------------------------------------------------------------------------------
|
|
20
|
+
|
|
21
|
+
| 0 | SELECT STATEMENT | | 21 | 2975 | 154 (82)| 00:00:02 |
|
|
22
|
+
|
|
23
|
+
| 1 | SORT UNIQUE | | 21 | 2975 | 154 (82)| 00:00:02 |
|
|
24
|
+
|
|
25
|
+
| 2 | UNION-ALL | | | | | |
|
|
26
|
+
|
|
27
|
+
|* 3 | FILTER | | | | | |
|
|
28
|
+
|
|
29
|
+
| 4 | NESTED LOOPS | | 1 | 145 | 28 (0)| 00:00:01 |
|
|
30
|
+
|
|
31
|
+
| 5 | TABLE ACCESS BY INDEX ROWID| TBFA004G | 20 | 700 | 8 (0)| 00:00:01 |
|
|
32
|
+
|
|
33
|
+
|* 6 | INDEX RANGE SCAN | TBFA004G_IX1 | 20 | | 6 (0)| 00:00:01 |
|
|
34
|
+
|
|
35
|
+
|* 7 | TABLE ACCESS BY INDEX ROWID| TBFA001G | 1 | 110 | 1 (0)| 00:00:01 |
|
|
36
|
+
|
|
37
|
+
|* 8 | INDEX UNIQUE SCAN | TBFA001G_PK | 1 | | 0 (0)| 00:00:01 |
|
|
38
|
+
|
|
39
|
+
|* 9 | INDEX UNIQUE SCAN | TBFA090G_PK | 1 | 16 | 1 (0)| 00:00:01 |
|
|
40
|
+
|
|
41
|
+
|* 10 | TABLE ACCESS BY INDEX ROWID| TBSA005G | 1 | 18 | 2 (0)| 00:00:01 |
|
|
42
|
+
|
|
43
|
+
| 11 | NESTED LOOPS | | 484 | 17424 | 21 (5)| 00:00:01 |
|
|
44
|
+
|
|
45
|
+
| 12 | INDEX FULL SCAN | TBFA090G_IX1 | 1045 | 18810 | 14 (0)| 00:00:01 |
|
|
46
|
+
|
|
47
|
+
|* 13 | INDEX RANGE SCAN | TBSA005G_PK | 1 | | 1 (0)| 00:00:01 |
|
|
48
|
+
|
|
49
|
+
|* 14 | INDEX UNIQUE SCAN | TBFA090G_PK | 1 | 16 | 1 (0)| 00:00:01 |
|
|
50
|
+
|
|
51
|
+
| 15 | NESTED LOOPS ANTI | | 19 | 2698 | 110 (0)| 00:00:02 |
|
|
52
|
+
|
|
53
|
+
|* 16 | TABLE ACCESS BY INDEX ROWID | TBFA001G | 19 | 2394 | 110 (0)| 00:00:02 |
|
|
54
|
+
|
|
55
|
+
|* 17 | INDEX RANGE SCAN | TBFA001G_PK | 400 | | 6 (0)| 00:00:01 |
|
|
56
|
+
|
|
57
|
+
|* 18 | INDEX UNIQUE SCAN | TBFA004G_PK | 1 | 16 | 0 (0)| 00:00:01 |
|
|
58
|
+
|
|
59
|
+
| 19 | NESTED LOOPS ANTI | | 1 | 132 | 13 (8)| 00:00:01 |
|
|
60
|
+
|
|
61
|
+
|* 20 | HASH JOIN SEMI | | 1 | 114 | 12 (9)| 00:00:01 |
|
|
62
|
+
|
|
63
|
+
|* 21 | TABLE ACCESS BY INDEX ROWID| TBFN009G | 2 | 192 | 9 (0)| 00:00:01 |
|
|
64
|
+
|
|
65
|
+
|* 22 | INDEX RANGE SCAN | TBFN009G_IX2 | 2 | | 7 (0)| 00:00:01 |
|
|
66
|
+
|
|
67
|
+
|* 23 | TABLE ACCESS FULL | TBSA005G | 40 | 720 | 2 (0)| 00:00:01 |
|
|
68
|
+
|
|
69
|
+
|* 24 | INDEX RANGE SCAN | TBFA090G_IX1 | 1 | 18 | 1 (0)| 00:00:01 |
|
|
70
|
+
|
|
71
|
+
------------------------------------------------------------------------------------------------
|
|
72
|
+
|
|
73
|
+
```
|
1
画像を追加しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
File without changes
|