| 1 |
715
|
bojilova
|
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 |
|
|
-------------
|