Revision 720
Added by Matt Jones almost 24 years ago
| test/stats/querydata.lst | ||
|---|---|---|
| 1 |
The SAS System 03:31 Wednesday, February 28, 2001 1 |
|
| 2 |
|
|
| 3 |
OBS METHOD NODES DEPTH QTIME HITS SEARCHED |
|
| 4 |
|
|
| 5 |
1 index 11889 0 0.86 1 . |
|
| 6 |
2 index 87054 0 2.86 1 . |
|
| 7 |
3 index 162219 0 4.97 2 . |
|
| 8 |
4 index 1428078 0 25.33 19 1428078 |
|
| 9 |
5 index 1503240 0 26.11 20 1503240 |
|
| 10 |
6 index 1578402 0 29.08 21 1578402 |
|
| 11 |
7 index 1653564 0 28.29 22 1653564 |
|
| 12 |
8 index 1728726 0 28.75 23 1728726 |
|
| 13 |
9 index 1803888 0 29.05 24 1803888 |
|
| 14 |
10 index 1879050 0 29.03 25 1879050 |
|
| 15 |
11 index 1954212 0 29.54 26 1954212 |
|
| 16 |
12 index 2029374 0 31.72 27 2029374 |
|
| 17 |
13 index 11889 1 0.53 1 . |
|
| 18 |
14 index 87054 1 0.52 1 . |
|
| 19 |
15 index 162219 1 0.53 2 . |
|
| 20 |
16 index 1428078 1 1.05 19 108 |
|
| 21 |
17 index 1503240 1 1.10 20 108 |
|
| 22 |
18 index 1578402 1 2.05 21 108 |
|
| 23 |
19 index 1653564 1 1.60 22 108 |
|
| 24 |
20 index 1728726 1 1.25 23 108 |
|
| 25 |
21 index 1803888 1 1.84 24 108 |
|
| 26 |
22 index 1879050 1 1.33 25 108 |
|
| 27 |
23 index 1954212 1 1.74 26 108 |
|
| 28 |
24 index 2029374 1 1.77 27 108 |
|
| 29 |
25 index 11889 2 0.61 1 . |
|
| 30 |
26 index 87054 2 0.53 1 . |
|
| 31 |
27 index 162219 2 0.50 2 . |
|
| 32 |
28 index 1428078 2 0.71 19 108 |
|
| 33 |
29 index 1503240 2 0.67 20 108 |
|
| 34 |
30 index 1578402 2 1.14 21 108 |
|
| 35 |
31 index 1653564 2 0.73 22 108 |
|
| 36 |
32 index 1728726 2 0.73 23 108 |
|
| 37 |
33 index 1803888 2 0.74 24 108 |
|
| 38 |
34 index 1879050 2 0.78 25 108 |
|
| 39 |
35 index 1954212 2 0.76 26 108 |
|
| 40 |
36 index 2029374 2 0.78 27 108 |
|
| 41 |
37 index 11889 3 0.54 1 . |
|
| 42 |
38 index 87054 3 0.50 1 . |
|
| 43 |
39 index 162219 3 0.54 2 . |
|
| 44 |
40 index 1428078 3 0.76 19 27 |
|
| 45 |
41 index 1503240 3 0.80 20 27 |
|
| 46 |
42 index 1578402 3 1.20 21 27 |
|
| 47 |
43 index 1653564 3 0.73 22 27 |
|
| 48 |
44 index 1728726 3 0.71 23 27 |
|
| 49 |
45 index 1803888 3 0.73 24 27 |
|
| 50 |
46 index 1879050 3 0.77 25 27 |
|
| 51 |
47 index 1954212 3 0.73 26 27 |
|
| 52 |
48 index 2029374 3 0.78 27 27 |
|
| 53 |
49 index 11889 4 0.52 1 . |
|
| 54 |
50 index 87054 4 0.58 1 . |
|
| 55 |
51 index 162219 4 0.51 2 . |
|
| 56 |
52 index 1428078 4 0.74 19 189 |
|
| 57 |
53 index 1503240 4 0.74 20 189 |
|
| 58 |
54 index 1578402 4 1.34 21 189 |
|
| 59 |
55 index 1653564 4 0.79 22 189 |
|
| 60 |
56 index 1728726 4 0.78 23 189 |
|
| 61 |
The SAS System 03:31 Wednesday, February 28, 2001 2 |
|
| 62 |
|
|
| 63 |
OBS METHOD NODES DEPTH QTIME HITS SEARCHED |
|
| 64 |
|
|
| 65 |
57 index 1803888 4 0.83 24 189 |
|
| 66 |
58 index 1879050 4 0.89 25 189 |
|
| 67 |
59 index 1954212 4 0.79 26 189 |
|
| 68 |
60 index 2029374 4 0.91 27 189 |
|
| 69 |
61 index 11889 5 0.63 1 . |
|
| 70 |
62 index 87054 5 0.68 1 . |
|
| 71 |
63 index 162219 5 0.86 2 . |
|
| 72 |
64 index 1428078 5 35.08 19 25083 |
|
| 73 |
65 index 1503240 5 35.21 20 25083 |
|
| 74 |
66 index 1578402 5 61.27 21 25083 |
|
| 75 |
67 index 1653564 5 37.39 22 25083 |
|
| 76 |
68 index 1728726 5 40.52 23 25083 |
|
| 77 |
69 index 1803888 5 43.68 24 25083 |
|
| 78 |
70 index 1879050 5 43.87 25 25083 |
|
| 79 |
71 index 1954212 5 46.22 26 25083 |
|
| 80 |
72 index 2029374 5 47.39 27 25083 |
|
| 81 |
73 index 11889 6 0.60 1 . |
|
| 82 |
74 index 87054 6 0.51 1 . |
|
| 83 |
75 index 162219 6 0.54 2 . |
|
| 84 |
76 index 1428078 6 2.46 19 594 |
|
| 85 |
77 index 1503240 6 2.68 20 594 |
|
| 86 |
78 index 1578402 6 3.12 21 594 |
|
| 87 |
79 index 1653564 6 2.71 22 594 |
|
| 88 |
80 index 1728726 6 2.95 23 594 |
|
| 89 |
81 index 1803888 6 3.09 24 594 |
|
| 90 |
82 index 1879050 6 3.18 25 594 |
|
| 91 |
83 index 1954212 6 3.20 26 594 |
|
| 92 |
84 index 2029374 6 3.43 27 594 |
|
| 93 |
85 nested 11889 0 0.73 1 . |
|
| 94 |
86 nested 87054 0 2.82 1 . |
|
| 95 |
87 nested 162219 0 5.02 2 . |
|
| 96 |
88 nested 1428078 0 8.40 19 1428078 |
|
| 97 |
89 nested 1503240 0 8.17 20 1503240 |
|
| 98 |
90 nested 1578402 0 8.57 21 1578402 |
|
| 99 |
91 nested 1653564 0 7.50 22 1653564 |
|
| 100 |
92 nested 1728726 0 7.75 23 1728726 |
|
| 101 |
93 nested 1803888 0 8.29 24 1803888 |
|
| 102 |
94 nested 1879050 0 9.17 25 1879050 |
|
| 103 |
95 nested 1954212 0 22.48 26 1954212 |
|
| 104 |
96 nested 2029374 0 28.67 27 2029374 |
|
| 105 |
97 nested 11889 1 0.56 1 . |
|
| 106 |
98 nested 87054 1 0.49 1 . |
|
| 107 |
99 nested 162219 1 0.53 2 . |
|
| 108 |
100 nested 1428078 1 0.70 19 108 |
|
| 109 |
101 nested 1503240 1 0.77 20 108 |
|
| 110 |
102 nested 1578402 1 1.31 21 108 |
|
| 111 |
103 nested 1653564 1 0.73 22 108 |
|
| 112 |
104 nested 1728726 1 0.68 23 108 |
|
| 113 |
105 nested 1803888 1 0.74 24 108 |
|
| 114 |
106 nested 1879050 1 0.79 25 108 |
|
| 115 |
107 nested 1954212 1 0.72 26 108 |
|
| 116 |
108 nested 2029374 1 0.81 27 108 |
|
| 117 |
109 nested 11889 2 0.62 1 . |
|
| 118 |
110 nested 87054 2 0.53 1 . |
|
| 119 |
111 nested 162219 2 0.50 2 . |
|
| 120 |
112 nested 1428078 2 0.65 19 108 |
|
| 121 |
The SAS System 03:31 Wednesday, February 28, 2001 3 |
|
| 122 |
|
|
| 123 |
OBS METHOD NODES DEPTH QTIME HITS SEARCHED |
|
| 124 |
|
|
| 125 |
113 nested 1503240 2 0.92 20 108 |
|
| 126 |
114 nested 1578402 2 1.30 21 108 |
|
| 127 |
115 nested 1653564 2 0.79 22 108 |
|
| 128 |
116 nested 1728726 2 0.70 23 108 |
|
| 129 |
117 nested 1803888 2 0.80 24 108 |
|
| 130 |
118 nested 1879050 2 0.80 25 108 |
|
| 131 |
119 nested 1954212 2 0.78 26 108 |
|
| 132 |
120 nested 2029374 2 0.83 27 108 |
|
| 133 |
121 nested 11889 3 0.61 1 . |
|
| 134 |
122 nested 87054 3 0.50 1 . |
|
| 135 |
123 nested 162219 3 0.51 2 . |
|
| 136 |
124 nested 1428078 3 0.68 19 27 |
|
| 137 |
125 nested 1503240 3 0.84 20 27 |
|
| 138 |
126 nested 1578402 3 1.17 21 27 |
|
| 139 |
127 nested 1653564 3 0.70 22 27 |
|
| 140 |
128 nested 1728726 3 0.70 23 27 |
|
| 141 |
129 nested 1803888 3 0.69 24 27 |
|
| 142 |
130 nested 1879050 3 0.74 25 27 |
|
| 143 |
131 nested 1954212 3 0.75 26 27 |
|
| 144 |
132 nested 2029374 3 0.72 27 27 |
|
| 145 |
133 nested 11889 4 0.59 1 . |
|
| 146 |
134 nested 87054 4 0.53 1 . |
|
| 147 |
135 nested 162219 4 0.51 2 . |
|
| 148 |
136 nested 1428078 4 0.73 19 189 |
|
| 149 |
137 nested 1503240 4 0.85 20 189 |
|
| 150 |
138 nested 1578402 4 1.28 21 189 |
|
| 151 |
139 nested 1653564 4 0.85 22 189 |
|
| 152 |
140 nested 1728726 4 0.78 23 189 |
|
| 153 |
141 nested 1803888 4 0.77 24 189 |
|
| 154 |
142 nested 1879050 4 0.80 25 189 |
|
| 155 |
143 nested 1954212 4 0.82 26 189 |
|
| 156 |
144 nested 2029374 4 0.83 27 189 |
|
| 157 |
145 nested 11889 5 0.83 1 . |
|
| 158 |
146 nested 87054 5 0.65 1 . |
|
| 159 |
147 nested 162219 5 0.87 2 . |
|
| 160 |
148 nested 1428078 5 7.77 19 25083 |
|
| 161 |
149 nested 1503240 5 8.36 20 25083 |
|
| 162 |
150 nested 1578402 5 12.09 21 25083 |
|
| 163 |
151 nested 1653564 5 8.47 22 25083 |
|
| 164 |
152 nested 1728726 5 8.70 23 25083 |
|
| 165 |
153 nested 1803888 5 8.84 24 25083 |
|
| 166 |
154 nested 1879050 5 8.96 25 25083 |
|
| 167 |
155 nested 1954212 5 9.71 26 25083 |
|
| 168 |
156 nested 2029374 5 10.84 27 25083 |
|
| 169 |
157 nested 11889 6 0.86 1 . |
|
| 170 |
158 nested 87054 6 0.50 1 . |
|
| 171 |
159 nested 162219 6 0.53 2 . |
|
| 172 |
160 nested 1428078 6 0.74 19 594 |
|
| 173 |
161 nested 1503240 6 0.88 20 594 |
|
| 174 |
162 nested 1578402 6 1.22 21 594 |
|
| 175 |
163 nested 1653564 6 0.81 22 594 |
|
| 176 |
164 nested 1728726 6 0.81 23 594 |
|
| 177 |
165 nested 1803888 6 0.94 24 594 |
|
| 178 |
166 nested 1879050 6 0.84 25 594 |
|
| 179 |
167 nested 1954212 6 0.93 26 594 |
|
| 180 |
168 nested 2029374 6 0.86 27 594 |
|
| 181 |
The SAS System 03:31 Wednesday, February 28, 2001 4 |
|
| 182 |
|
|
| 183 |
General Linear Models Procedure |
|
| 184 |
Class Level Information |
|
| 185 |
|
|
| 186 |
Class Levels Values |
|
| 187 |
|
|
| 188 |
METHOD 2 index nested |
|
| 189 |
|
|
| 190 |
|
|
| 191 |
Number of observations in data set = 168 |
|
| 192 |
|
|
| 193 |
|
|
| 194 |
NOTE: Due to missing values, only 126 observations can be used in this |
|
| 195 |
analysis. |
|
| 196 |
|
|
| 197 |
The SAS System 03:31 Wednesday, February 28, 2001 5 |
|
| 198 |
|
|
| 199 |
General Linear Models Procedure |
|
| 200 |
|
|
| 201 |
Dependent Variable: QTIME |
|
| 202 |
Sum of Mean |
|
| 203 |
Source DF Squares Square F Value Pr > F |
|
| 204 |
|
|
| 205 |
Model 4 7401.184408 1850.296102 16.99 0.0001 |
|
| 206 |
|
|
| 207 |
Error 121 13174.988939 108.884206 |
|
| 208 |
|
|
| 209 |
Corrected Total 125 20576.173347 |
|
| 210 |
|
|
| 211 |
R-Square C.V. Root MSE QTIME Mean |
|
| 212 |
|
|
| 213 |
0.359697 139.8062 10.43476 7.463730 |
|
| 214 |
|
|
| 215 |
|
|
| 216 |
Source DF Type I SS Mean Square F Value Pr > F |
|
| 217 |
|
|
| 218 |
METHOD 1 1827.428750 1827.428750 16.78 0.0001 |
|
| 219 |
NODES 1 64.037530 64.037530 0.59 0.4446 |
|
| 220 |
DEPTH 1 14.490896 14.490896 0.13 0.7159 |
|
| 221 |
SEARCHED 1 5495.227232 5495.227232 50.47 0.0001 |
|
| 222 |
|
|
| 223 |
Source DF Type III SS Mean Square F Value Pr > F |
|
| 224 |
|
|
| 225 |
METHOD 1 1827.428750 1827.428750 16.78 0.0001 |
|
| 226 |
NODES 1 14.064335 14.064335 0.13 0.7199 |
|
| 227 |
DEPTH 1 1741.699812 1741.699812 16.00 0.0001 |
|
| 228 |
SEARCHED 1 5495.227232 5495.227232 50.47 0.0001 |
|
| 229 |
|
|
| 230 |
|
|
| 231 |
|
|
| 232 |
The SAS System 03:31 Wednesday, February 28, 2001 6 |
|
| 233 |
|
|
| 234 |
Plot of QTIME*DEPTH. Legend: A = 1 obs, B = 2 obs, etc. |
|
| 235 |
|
|
| 236 |
QTIME | |
|
| 237 |
60.97 + A |
|
| 238 |
| |
|
| 239 |
| |
|
| 240 |
| |
|
| 241 |
55.93 + |
|
| 242 |
| |
|
| 243 |
| |
|
| 244 |
| |
|
| 245 |
50.89 + |
|
| 246 |
| |
|
| 247 |
| |
|
| 248 |
| A |
|
| 249 |
45.85 + A |
|
| 250 |
| |
|
| 251 |
| B |
|
| 252 |
| |
|
| 253 |
40.81 + A |
|
| 254 |
| |
|
| 255 |
| |
|
| 256 |
| A |
|
| 257 |
35.77 + A |
|
| 258 |
| A |
|
| 259 |
| |
|
| 260 |
| A |
|
| 261 |
30.73 + |
|
| 262 |
| D |
|
| 263 |
| C |
|
| 264 |
| |
|
| 265 |
25.69 + B |
|
| 266 |
| |
|
| 267 |
| |
|
| 268 |
| A |
|
| 269 |
20.65 + |
|
| 270 |
| |
|
| 271 |
| |
|
| 272 |
| |
|
| 273 |
15.61 + |
|
| 274 |
| |
|
| 275 |
| |
|
| 276 |
| A |
|
| 277 |
10.57 + A |
|
| 278 |
| A D |
|
| 279 |
| F C |
|
| 280 |
| |
|
| 281 |
5.53 + B |
|
| 282 |
| |
|
| 283 |
| B I |
|
| 284 |
| H B B B A |
|
| 285 |
0.49 + B P V V V F N |
|
| 286 |
---+----------+----------+----------+----------+----------+----------+-- |
|
| 287 |
0 1 2 3 4 5 6 |
|
| 288 |
|
|
| 289 |
DEPTH |
|
| 290 |
|
|
| 291 |
|
|
| 292 |
The SAS System 03:31 Wednesday, February 28, 2001 7 |
|
| 293 |
|
|
| 294 |
Plot of QTIME*NODES. Legend: A = 1 obs, B = 2 obs, etc. |
|
| 295 |
|
|
| 296 |
QTIME | |
|
| 297 |
60.97 + A |
|
| 298 |
| |
|
| 299 |
| |
|
| 300 |
| |
|
| 301 |
55.93 + |
|
| 302 |
| |
|
| 303 |
| |
|
| 304 |
| |
|
| 305 |
50.89 + |
|
| 306 |
| |
|
| 307 |
| |
|
| 308 |
| A |
|
| 309 |
45.85 + A |
|
| 310 |
| |
|
| 311 |
| A A |
|
| 312 |
| |
|
| 313 |
40.81 + A |
|
| 314 |
| |
|
| 315 |
| |
|
| 316 |
| A |
|
| 317 |
35.77 + A |
|
| 318 |
| A |
|
| 319 |
| |
|
| 320 |
| A |
|
| 321 |
30.73 + |
|
| 322 |
| A A A A |
|
| 323 |
| A A A |
|
| 324 |
| |
|
| 325 |
25.69 + A A |
|
| 326 |
| |
|
| 327 |
| |
|
| 328 |
| A |
|
| 329 |
20.65 + |
|
| 330 |
| |
|
| 331 |
| |
|
| 332 |
| |
|
| 333 |
15.61 + |
|
| 334 |
| |
|
| 335 |
| |
|
| 336 |
| A |
|
| 337 |
10.57 + A |
|
| 338 |
| A A B A |
|
| 339 |
| B B A B A A |
|
| 340 |
| |
|
| 341 |
5.53 + B |
|
| 342 |
| |
|
| 343 |
| B A A A A A A A A A |
|
| 344 |
| I A A A A A A |
|
| 345 |
0.49 +N L L I I H H H H H H |
|
| 346 |
-+-------------+-------------+-------------+-------------+-------------+ |
|
| 347 |
0 500000 1000000 1500000 2000000 2500000 |
|
| 348 |
|
|
| 349 |
NODES |
|
| 350 |
|
|
| 351 |
|
|
| 352 |
The SAS System 03:31 Wednesday, February 28, 2001 8 |
|
| 353 |
|
|
| 354 |
Plot of QTIME*SEARCHED. Legend: A = 1 obs, B = 2 obs, etc. |
|
| 355 |
|
|
| 356 |
QTIME | |
|
| 357 |
60.97 + A |
|
| 358 |
| |
|
| 359 |
| |
|
| 360 |
| |
|
| 361 |
55.93 + |
|
| 362 |
| |
|
| 363 |
| |
|
| 364 |
| |
|
| 365 |
50.89 + |
|
| 366 |
| |
|
| 367 |
| |
|
| 368 |
| A |
|
| 369 |
45.85 + A |
|
| 370 |
| |
|
| 371 |
| B |
|
| 372 |
| |
|
| 373 |
40.81 + A |
|
| 374 |
| |
|
| 375 |
| |
|
| 376 |
| A |
|
| 377 |
35.77 + A |
|
| 378 |
| A |
|
| 379 |
| |
|
| 380 |
| A |
|
| 381 |
30.73 + |
|
| 382 |
| A A A A |
|
| 383 |
| A A A |
|
| 384 |
| |
|
| 385 |
25.69 + A A |
|
| 386 |
| |
|
| 387 |
| |
|
| 388 |
| A |
|
| 389 |
20.65 + |
|
| 390 |
| |
|
| 391 |
| |
|
| 392 |
| |
|
| 393 |
15.61 + |
|
| 394 |
| |
|
| 395 |
| |
|
| 396 |
| A |
|
| 397 |
10.57 + A |
|
| 398 |
| D A |
|
| 399 |
| C A A A A A A |
|
| 400 |
| |
|
| 401 |
5.53 + |
|
| 402 |
| |
|
| 403 |
|I |
|
| 404 |
|O |
|
| 405 |
0.49 +Z |
|
| 406 |
-+-------------+-------------+-------------+-------------+-------------+ |
|
| 407 |
0 500000 1000000 1500000 2000000 2500000 |
|
| 408 |
|
|
| 409 |
SEARCHED |
|
| 410 |
|
|
| 411 |
NOTE: 42 obs had missing values. 40 obs hidden. |
|
| 0 | 412 | |
Also available in: Unified diff
Added results of running the query analysis.