|
1
|
SQL> select count(*) from xml_nodes;
|
|
2
|
|
|
3
|
COUNT(*)
|
|
4
|
---------
|
|
5
|
11889
|
|
6
|
|
|
7
|
---------------------TSTMT------------------
|
|
8
|
TSTMT INDEXED DEPTH 0 17.48 16.616 0.864 1
|
|
9
|
TSTMT INDEXED DEPTH 1 4.325 3.793 0.532 1
|
|
10
|
TSTMT INDEXED DEPTH 2 6.311 5.698 0.613 1
|
|
11
|
TSTMT INDEXED DEPTH 3 1.54 1.002 0.538 1
|
|
12
|
TSTMT INDEXED DEPTH 4 1.538 1.015 0.523 1
|
|
13
|
TSTMT INDEXED DEPTH 5 1.587 0.961 0.626 1
|
|
14
|
TSTMT INDEXED DEPTH 6 1.52 0.92 0.6 1
|
|
15
|
TSTMT NONINDEXED DEPTH 0 1.814 1.086 0.728 1
|
|
16
|
TSTMT NONINDEXED DEPTH 1 5.934 5.379 0.555 1
|
|
17
|
TSTMT NONINDEXED DEPTH 2 1.486 0.869 0.617 1
|
|
18
|
TSTMT NONINDEXED DEPTH 3 1.437 0.829 0.608 1
|
|
19
|
TSTMT NONINDEXED DEPTH 4 1.608 1.016 0.592 1
|
|
20
|
TSTMT NONINDEXED DEPTH 5 1.814 0.988 0.826 1
|
|
21
|
TSTMT NONINDEXED DEPTH 6 2.353 1.497 0.856 1
|
|
22
|
-------------
|
|
23
|
TEST COMPLETE
|
|
24
|
-------------
|
|
25
|
|
|
26
|
SQL> select count(*) from xml_nodes;
|
|
27
|
|
|
28
|
COUNT(*)
|
|
29
|
---------
|
|
30
|
87054
|
|
31
|
|
|
32
|
---------------------TSTMT------------------
|
|
33
|
TSTMT INDEXED DEPTH 0 3.736 0.876 2.86 1
|
|
34
|
TSTMT INDEXED DEPTH 1 1.322 0.801 0.521 1
|
|
35
|
TSTMT INDEXED DEPTH 2 1.296 0.769 0.527 1
|
|
36
|
TSTMT INDEXED DEPTH 3 1.296 0.8 0.496 1
|
|
37
|
TSTMT INDEXED DEPTH 4 1.35 0.771 0.579 1
|
|
38
|
TSTMT INDEXED DEPTH 5 1.486 0.805 0.681 1
|
|
39
|
TSTMT INDEXED DEPTH 6 1.316 0.802 0.514 1
|
|
40
|
TSTMT NONINDEXED DEPTH 0 3.714 0.886 2.828 1
|
|
41
|
TSTMT NONINDEXED DEPTH 1 1.297 0.803 0.494 1
|
|
42
|
TSTMT NONINDEXED DEPTH 2 1.3 0.773 0.527 1
|
|
43
|
TSTMT NONINDEXED DEPTH 3 1.298 0.803 0.495 1
|
|
44
|
TSTMT NONINDEXED DEPTH 4 1.303 0.772 0.531 1
|
|
45
|
TSTMT NONINDEXED DEPTH 5 1.455 0.803 0.652 1
|
|
46
|
TSTMT NONINDEXED DEPTH 6 1.301 0.803 0.498 1
|
|
47
|
-------------
|
|
48
|
TEST COMPLETE
|
|
49
|
-------------
|
|
50
|
|
|
51
|
SQL> select count(*) from xml_nodes;
|
|
52
|
|
|
53
|
COUNT(*)
|
|
54
|
---------
|
|
55
|
162219
|
|
56
|
|
|
57
|
---------------------TSTMT------------------
|
|
58
|
TSTMT INDEXED DEPTH 0 5.85 0.878 4.972 2
|
|
59
|
TSTMT INDEXED DEPTH 1 1.296 0.768 0.528 2
|
|
60
|
TSTMT INDEXED DEPTH 2 1.306 0.802 0.504 2
|
|
61
|
TSTMT INDEXED DEPTH 3 1.361 0.824 0.537 2
|
|
62
|
TSTMT INDEXED DEPTH 4 1.307 0.802 0.505 2
|
|
63
|
TSTMT INDEXED DEPTH 5 1.663 0.801 0.862 2
|
|
64
|
TSTMT INDEXED DEPTH 6 1.31 0.771 0.539 2
|
|
65
|
TSTMT NONINDEXED DEPTH 0 5.821 0.806 5.015 2
|
|
66
|
TSTMT NONINDEXED DEPTH 1 1.3 0.769 0.531 2
|
|
67
|
TSTMT NONINDEXED DEPTH 2 1.367 0.863 0.504 2
|
|
68
|
TSTMT NONINDEXED DEPTH 3 1.305 0.798 0.507 2
|
|
69
|
TSTMT NONINDEXED DEPTH 4 1.307 0.802 0.505 2
|
|
70
|
TSTMT NONINDEXED DEPTH 5 1.72 0.855 0.865 2
|
|
71
|
TSTMT NONINDEXED DEPTH 6 1.304 0.77 0.534 2
|
|
72
|
-------------
|
|
73
|
TEST COMPLETE
|
|
74
|
-------------
|