Complete Linux

home *** CD-ROM | disk | FTP | other *** search

/ Complete Linux / Complete Linux.iso / docs / apps / database / postgres / postgre2.z / postgre2 / doc / implementation / planner / figure3.9 < prev next >

Wrap

Text File | 1992-08-27 | 5.5 KB | 583 lines

sungremlinfile 0 292.00 244.00 TOPCENT 292.00 244.00 243.00 235.00 292.00 235.00 341.00 235.00 * 1 1 13 TEMP1.hobbies VECTOR 296.00 368.00 301.60 371.36 297.57 371.14 295.32 374.50 296.00 368.00 * 5 0 0 TOPCENT 108.00 408.00 54.00 399.00 108.00 399.00 162.00 399.00 * 1 1 13 TEMP1 and EMP CENTCENT 240.00 480.00 137.00 476.00 240.00 476.00 344.00 476.00 * 1 1 30 retrieve (EMP.name, TEMP3.avg) VECTOR 132.00 488.00 132.00 468.00 344.00 468.00 344.00 488.00 132.00 488.00 * 5 0 0 TOPCENT 108.00 420.00 63.00 411.00 108.00 411.00 153.00 411.00 * 1 1 9 MERGESORT TOPCENT 108.00 396.00 78.00 387.00 108.00 387.00 138.00 387.00 * 1 1 10 retrieving TOPCENT 108.00 384.00 31.00 375.00 108.00 375.00 186.00 375.00 * 1 1 21 EMP.name, EMP.hobbies TOPCENT 108.00 372.00 90.00 363.00 108.00 363.00 126.00 363.00 * 1 1 5 where TOPCENT 108.00 360.00 21.00 351.00 108.00 351.00 196.00 351.00 * 1 1 22 TEMP1.dname = EMP.dept TOPCENT 48.00 304.00 29.00 295.00 48.00 295.00 68.00 295.00 * 1 1 4 SCAN TOPCENT 48.00 292.00 25.00 283.00 48.00 283.00 72.00 283.00 * 1 1 5 TEMP1 VECTOR 48.00 280.00 48.00 256.00 * 5 0 0 VECTOR 48.00 256.00 51.51 261.51 48.00 259.51 44.49 261.51 48.00 256.00 * 5 0 0 TOPCENT 48.00 248.00 29.00 239.00 48.00 239.00 68.00 239.00 * 1 1 4 SORT TOPCENT 48.00 236.00 29.00 227.00 48.00 227.00 67.00 227.00 * 1 1 4 DEPT TOPCENT 48.00 224.00 19.00 215.00 48.00 215.00 78.00 215.00 * 1 1 8 on dname TOPCENT 48.00 212.00 10.00 203.00 48.00 203.00 86.00 203.00 * 1 1 10 into TEMP1 VECTOR 48.00 200.00 48.00 176.00 * 5 0 0 VECTOR 48.00 176.00 51.51 181.51 48.00 179.51 44.49 181.51 48.00 176.00 * 5 0 0 TOPCENT 48.00 172.00 6.00 163.00 48.00 163.00 90.00 163.00 * 1 1 9 INDEXSCAN TOPCENT 48.00 148.00 15.00 139.00 48.00 139.00 81.00 139.00 * 1 1 11 floor index TOPCENT 48.00 136.00 30.00 127.00 48.00 127.00 66.00 127.00 * 1 1 5 where TOPCENT 48.00 124.00 19.00 115.00 48.00 115.00 77.00 115.00 * 1 1 9 floor = 1 TOPCENT 48.00 112.00 18.00 103.00 48.00 103.00 78.00 103.00 * 1 1 10 retrieving TOPCENT 48.00 100.00 28.00 91.00 48.00 91.00 68.00 91.00 * 1 1 5 dname TOPCENT 164.00 292.00 131.00 283.00 164.00 283.00 198.00 283.00 * 1 1 9 EMP using TOPCENT 164.00 280.00 132.00 271.00 164.00 271.00 197.00 271.00 * 1 1 10 dept index TOPCENT 164.00 268.00 134.00 259.00 164.00 259.00 194.00 259.00 * 1 1 10 retrieving TOPCENT 168.00 256.00 113.00 247.00 168.00 247.00 223.00 247.00 * 1 1 16 name and hobbies VECTOR 84.00 348.00 48.00 308.00 * 5 0 0 VECTOR 48.00 308.00 54.38 309.41 50.48 310.48 49.41 314.38 48.00 308.00 * 5 0 0 VECTOR 136.00 344.00 160.00 308.00 * 5 0 0 VECTOR 160.00 308.00 160.68 314.50 158.43 311.14 154.40 311.36 160.00 308.00 * 5 0 0 VECTOR 4.00 84.00 4.00 428.00 224.00 428.00 224.00 84.00 4.00 84.00 * 5 0 0 TOPCENT 368.00 420.00 302.00 411.00 368.00 411.00 435.00 411.00 * 1 1 20 retrieve (TEMP3.avg) VECTOR 296.00 424.00 296.00 404.00 440.00 404.00 440.00 424.00 296.00 424.00 * 5 0 0 TOPCENT 164.00 304.00 122.00 295.00 164.00 295.00 206.00 295.00 * 1 1 9 INDEXSCAN TOPCENT 48.00 160.00 11.00 151.00 48.00 151.00 86.00 151.00 * 1 1 10 DEPT using TOPCENT 296.00 364.00 277.00 355.00 296.00 355.00 316.00 355.00 * 1 1 4 SCAN TOPCENT 296.00 352.00 273.00 343.00 296.00 343.00 320.00 343.00 * 1 1 5 TEMP2 TOPCENT 296.00 340.00 266.00 331.00 296.00 331.00 326.00 331.00 * 1 1 10 retrieving TOPCENT 296.00 328.00 249.00 319.00 296.00 319.00 344.00 319.00 * 1 1 15 batting-history TOPCENT 296.00 316.00 278.00 307.00 296.00 307.00 314.00 307.00 * 1 1 5 where TOPCENT 296.00 304.00 238.00 295.00 296.00 295.00 355.00 295.00 * 1 1 18 position = catcher VECTOR 292.00 292.00 292.00 264.00 * 1 0 0 VECTOR 292.00 264.00 295.51 269.51 292.00 267.51 288.49 269.51 292.00 264.00 * 5 0 0 TOPCENT 292.00 256.00 244.00 247.00 292.00 247.00 340.00 247.00 * 1 1 11 MATERIALIZE TOPCENT 288.00 232.00 250.00 223.00 288.00 223.00 326.00 223.00 * 1 1 10 into TEMP2 VECTOR 232.00 368.00 232.00 212.00 356.00 212.00 356.00 368.00 232.00 368.00 * 5 0 0 VECTOR 172.00 468.00 104.00 428.00 * 5 0 0 VECTOR 104.00 428.00 110.53 428.14 106.92 429.95 106.64 433.98 104.00 428.00 * 5 0 0 VECTOR 304.00 468.00 368.00 424.00 * 5 0 0 VECTOR 368.00 424.00 365.36 429.98 365.08 425.95 361.47 424.14 368.00 424.00 * 5 0 0 VECTOR 332.00 404.00 296.00 368.00 * 5 0 0 TOPCENT 432.00 200.00 413.00 191.00 432.00 191.00 452.00 191.00 * 1 1 4 SCAN TOPCENT 432.00 188.00 409.00 179.00 432.00 179.00 456.00 179.00 * 1 1 5 TEMP3 TOPCENT 432.00 176.00 390.00 167.00 432.00 167.00 475.00 167.00 * 1 1 14 retrieving avg TOPCENT 432.00 164.00 412.00 155.00 432.00 155.00 452.00 155.00 * 1 1 6 where TOPCENT 432.00 152.00 394.00 143.00 432.00 143.00 470.00 143.00 * 1 1 11 year = 1986 VECTOR 428.00 136.00 428.00 112.00 * 1 0 0 VECTOR 428.00 112.00 431.51 117.51 428.00 115.51 424.49 117.51 428.00 112.00 * 5 0 0 TOPCENT 428.00 108.00 380.00 99.00 428.00 99.00 476.00 99.00 * 1 1 11 MATERIALIZE TOPCENT 428.00 96.00 355.00 87.00 428.00 87.00 501.00 87.00 * 1 1 21 TEMP2.batting-history TOPCENT 428.00 84.00 390.00 75.00 428.00 75.00 466.00 75.00 * 1 1 10 into TEMP3 VECTOR 348.00 60.00 348.00 204.00 508.00 204.00 508.00 60.00 348.00 60.00 * 5 0 0 VECTOR 400.00 404.00 428.00 204.00 * 5 0 0 VECTOR 428.00 204.00 429.59 210.34 426.89 207.33 422.93 208.12 428.00 204.00 * 5 0 0 TOPCENT 180.00 504.00 171.00 496.00 180.00 496.00 190.00 496.00 * 3 1 2 R1 TOPCENT 72.00 448.00 63.00 440.00 72.00 440.00 82.00 440.00 * 3 1 2 P1 TOPCENT 388.00 448.00 379.00 440.00 388.00 440.00 398.00 440.00 * 3 1 2 R2 TOPCENT 264.00 384.00 255.00 376.00 264.00 376.00 274.00 376.00 * 3 1 2 P2 TOPCENT 472.00 228.00 463.00 220.00 472.00 220.00 482.00 220.00 * 3 1 2 P3 -1