Complete Linux

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

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

Wrap

Text File | 1992-08-27 | 11.9 KB | 1,332 lines

sungremlinfile 0 8.00 12.00 VECTOR 8.00 12.00 504.00 12.00 * 6 0 0 VECTOR 8.00 508.00 504.00 508.00 * 6 0 0 CENTCENT 372.00 28.00 363.00 24.00 372.00 24.00 381.00 24.00 * 3 1 3 (f) VECTOR 384.00 140.00 368.00 128.00 * 5 0 0 CENTCENT 372.00 384.00 362.00 380.00 372.00 380.00 383.00 380.00 * 3 1 3 (b) CENTCENT 372.00 268.00 362.00 264.00 372.00 264.00 383.00 264.00 * 3 1 3 (d) CENTCENT 188.00 172.00 163.00 168.00 188.00 168.00 213.00 168.00 * 1 1 7 (dname) CENTCENT 196.00 184.00 155.00 180.00 196.00 180.00 238.00 180.00 * 1 1 9 DEPTINDEX VECTOR 180.00 208.00 184.00 200.00 * 5 0 0 CENTCENT 188.00 196.00 158.00 192.00 188.00 192.00 218.00 192.00 * 1 1 9 indexscan CENTCENT 128.00 152.00 113.00 148.00 128.00 148.00 143.00 148.00 * 1 1 3 EMP CENTCENT 128.00 164.00 115.00 160.00 128.00 160.00 142.00 160.00 * 1 1 4 scan VECTOR 128.00 176.00 128.00 168.00 * 5 0 0 VECTOR 136.00 208.00 132.00 200.00 * 5 0 0 CENTCENT 132.00 184.00 118.00 180.00 132.00 180.00 146.00 180.00 * 1 1 4 dept CENTCENT 132.00 196.00 120.00 192.00 132.00 192.00 145.00 192.00 * 1 1 4 sort VECTOR 212.00 236.00 216.00 228.00 * 5 0 0 CENTCENT 220.00 212.00 201.00 208.00 220.00 208.00 239.00 208.00 * 1 1 4 DEPT CENTCENT 220.00 224.00 207.00 220.00 220.00 220.00 234.00 220.00 * 1 1 4 scan CENTCENT 160.00 216.00 127.00 212.00 160.00 212.00 194.00 212.00 * 1 1 11 Join - dept VECTOR 164.00 236.00 156.00 224.00 * 5 0 0 CENTCENT 192.00 244.00 164.00 240.00 192.00 240.00 221.00 240.00 * 1 1 10 Join - tid CENTCENT 72.00 164.00 47.00 160.00 72.00 160.00 97.00 160.00 * 1 1 7 (dname) CENTCENT 76.00 212.00 46.00 208.00 76.00 208.00 106.00 208.00 * 1 1 9 indexscan CENTCENT 76.00 200.00 57.00 196.00 76.00 196.00 95.00 196.00 * 1 1 4 DEPT VECTOR 68.00 236.00 76.00 220.00 * 5 0 0 CENTCENT 20.00 200.00 5.00 196.00 20.00 196.00 35.00 196.00 * 1 1 3 EMP CENTCENT 20.00 212.00 7.00 208.00 20.00 208.00 34.00 208.00 * 1 1 4 scan VECTOR 40.00 236.00 32.00 220.00 * 5 0 0 CENTCENT 56.00 244.00 47.00 240.00 56.00 240.00 66.00 240.00 * 1 1 2 NL CENTCENT 108.00 268.00 99.00 264.00 108.00 264.00 118.00 264.00 * 3 1 3 (c) VECTOR 8.00 256.00 504.00 256.00 * 6 0 0 CENTCENT 420.00 300.00 401.00 296.00 420.00 296.00 440.00 296.00 * 1 1 7 (floor) CENTCENT 424.00 324.00 394.00 320.00 424.00 320.00 454.00 320.00 * 1 1 9 indexscan CENTCENT 424.00 312.00 405.00 308.00 424.00 308.00 443.00 308.00 * 1 1 4 DEPT CENTCENT 320.00 300.00 301.00 296.00 320.00 296.00 340.00 296.00 * 1 1 7 (floor) CENTCENT 324.00 324.00 294.00 320.00 324.00 320.00 354.00 320.00 * 1 1 9 indexscan VECTOR 472.00 348.00 484.00 340.00 * 5 0 0 CENTCENT 484.00 284.00 469.00 280.00 484.00 280.00 499.00 280.00 * 1 1 3 EMP CENTCENT 484.00 296.00 471.00 292.00 484.00 292.00 498.00 292.00 * 1 1 4 scan VECTOR 484.00 312.00 484.00 300.00 * 5 0 0 CENTCENT 484.00 324.00 470.00 320.00 484.00 320.00 498.00 320.00 * 1 1 4 dept CENTCENT 484.00 336.00 472.00 332.00 484.00 332.00 497.00 332.00 * 1 1 4 sort VECTOR 432.00 348.00 424.00 332.00 * 5 0 0 CENTCENT 456.00 356.00 417.00 352.00 456.00 352.00 496.00 352.00 * 1 1 12 Join - dname CENTCENT 324.00 312.00 305.00 308.00 324.00 308.00 343.00 308.00 * 1 1 4 DEPT VECTOR 316.00 348.00 324.00 332.00 * 5 0 0 CENTCENT 268.00 312.00 253.00 308.00 268.00 308.00 283.00 308.00 * 1 1 3 EMP CENTCENT 268.00 324.00 255.00 320.00 268.00 320.00 282.00 320.00 * 1 1 4 scan VECTOR 288.00 348.00 280.00 332.00 * 5 0 0 CENTCENT 304.00 356.00 295.00 352.00 304.00 352.00 314.00 352.00 * 1 1 2 NL VECTOR 200.00 348.00 212.00 340.00 * 5 0 0 CENTCENT 212.00 284.00 197.00 280.00 212.00 280.00 227.00 280.00 * 1 1 3 EMP CENTCENT 212.00 296.00 199.00 292.00 212.00 292.00 226.00 292.00 * 1 1 4 scan VECTOR 212.00 312.00 212.00 300.00 * 5 0 0 CENTCENT 212.00 324.00 198.00 320.00 212.00 320.00 226.00 320.00 * 1 1 4 dept CENTCENT 212.00 336.00 200.00 332.00 212.00 332.00 225.00 332.00 * 1 1 4 sort CENTCENT 144.00 312.00 125.00 308.00 144.00 308.00 163.00 308.00 * 1 1 4 DEPT CENTCENT 148.00 324.00 135.00 320.00 148.00 320.00 162.00 320.00 * 1 1 4 scan VECTOR 160.00 348.00 152.00 332.00 * 5 0 0 CENTCENT 184.00 356.00 145.00 352.00 184.00 352.00 224.00 352.00 * 1 1 12 Join - dname VECTOR 8.00 368.00 504.00 368.00 * 6 0 0 VECTOR 240.00 508.00 240.00 12.00 * 6 0 0 CENTCENT 68.00 312.00 49.00 308.00 68.00 308.00 87.00 308.00 * 1 1 4 DEPT CENTCENT 68.00 324.00 55.00 320.00 68.00 320.00 82.00 320.00 * 1 1 4 scan VECTOR 60.00 348.00 68.00 332.00 * 5 0 0 CENTCENT 24.00 312.00 9.00 308.00 24.00 308.00 39.00 308.00 * 1 1 3 EMP CENTCENT 24.00 324.00 11.00 320.00 24.00 320.00 38.00 320.00 * 1 1 4 scan VECTOR 32.00 348.00 24.00 332.00 * 5 0 0 CENTCENT 48.00 356.00 39.00 352.00 48.00 352.00 58.00 352.00 * 1 1 2 NL CENTCENT 108.00 384.00 98.00 380.00 108.00 380.00 118.00 380.00 * 3 1 3 (a) CENTCENT 416.00 404.00 397.00 400.00 416.00 400.00 436.00 400.00 * 1 1 7 (floor) CENTCENT 416.00 428.00 386.00 424.00 416.00 424.00 446.00 424.00 * 1 1 9 indexscan CENTCENT 284.00 404.00 265.00 400.00 284.00 400.00 304.00 400.00 * 1 1 7 (floor) CENTCENT 52.00 500.00 16.00 496.00 52.00 496.00 89.00 496.00 * 1 1 10 MS - dname VECTOR 28.00 492.00 24.00 476.00 * 5 0 0 CENTCENT 24.00 468.00 12.00 464.00 24.00 464.00 37.00 464.00 * 1 1 4 sort CENTCENT 24.00 460.00 4.00 456.00 24.00 456.00 44.00 456.00 * 1 1 5 dname VECTOR 24.00 452.00 24.00 436.00 * 5 0 0 CENTCENT 24.00 428.00 11.00 424.00 24.00 424.00 38.00 424.00 * 1 1 4 scan CENTCENT 24.00 416.00 5.00 412.00 24.00 412.00 43.00 412.00 * 1 1 4 DEPT VECTOR 80.00 492.00 84.00 472.00 * 5 0 0 CENTCENT 84.00 468.00 72.00 464.00 84.00 464.00 97.00 464.00 * 1 1 4 sort CENTCENT 84.00 460.00 70.00 456.00 84.00 456.00 98.00 456.00 * 1 1 4 dept VECTOR 84.00 452.00 84.00 432.00 * 5 0 0 CENTCENT 84.00 428.00 71.00 424.00 84.00 424.00 98.00 424.00 * 1 1 4 scan CENTCENT 84.00 416.00 69.00 412.00 84.00 412.00 99.00 412.00 * 1 1 3 EMP VECTOR 156.00 492.00 152.00 476.00 * 5 0 0 CENTCENT 152.00 468.00 140.00 464.00 152.00 464.00 165.00 464.00 * 1 1 4 sort CENTCENT 152.00 460.00 132.00 456.00 152.00 456.00 172.00 456.00 * 1 1 5 dname VECTOR 152.00 452.00 152.00 436.00 * 5 0 0 CENTCENT 152.00 428.00 139.00 424.00 152.00 424.00 166.00 424.00 * 1 1 4 scan CENTCENT 152.00 416.00 133.00 412.00 152.00 412.00 171.00 412.00 * 1 1 4 DEPT VECTOR 208.00 492.00 212.00 472.00 * 5 0 0 CENTCENT 212.00 468.00 200.00 464.00 212.00 464.00 225.00 464.00 * 1 1 4 sort CENTCENT 212.00 460.00 198.00 456.00 212.00 456.00 226.00 456.00 * 1 1 4 dept VECTOR 212.00 452.00 212.00 432.00 * 5 0 0 CENTCENT 212.00 428.00 199.00 424.00 212.00 424.00 226.00 424.00 * 1 1 4 scan CENTCENT 212.00 416.00 197.00 412.00 212.00 412.00 227.00 412.00 * 1 1 3 EMP CENTCENT 184.00 500.00 145.00 496.00 184.00 496.00 224.00 496.00 * 1 1 12 Join - dname CENTCENT 316.00 500.00 280.00 496.00 316.00 496.00 353.00 496.00 * 1 1 10 MS - dname VECTOR 292.00 492.00 288.00 476.00 * 5 0 0 CENTCENT 288.00 468.00 276.00 464.00 288.00 464.00 301.00 464.00 * 1 1 4 sort CENTCENT 288.00 460.00 268.00 456.00 288.00 456.00 308.00 456.00 * 1 1 5 dname VECTOR 288.00 452.00 288.00 436.00 * 5 0 0 CENTCENT 288.00 416.00 269.00 412.00 288.00 412.00 307.00 412.00 * 1 1 4 DEPT VECTOR 344.00 492.00 348.00 472.00 * 5 0 0 CENTCENT 348.00 468.00 336.00 464.00 348.00 464.00 361.00 464.00 * 1 1 4 sort CENTCENT 348.00 460.00 334.00 456.00 348.00 456.00 362.00 456.00 * 1 1 4 dept VECTOR 348.00 452.00 348.00 432.00 * 5 0 0 CENTCENT 348.00 428.00 335.00 424.00 348.00 424.00 362.00 424.00 * 1 1 4 scan CENTCENT 348.00 416.00 333.00 412.00 348.00 412.00 363.00 412.00 * 1 1 3 EMP VECTOR 420.00 492.00 416.00 476.00 * 5 0 0 CENTCENT 416.00 468.00 404.00 464.00 416.00 464.00 429.00 464.00 * 1 1 4 sort CENTCENT 416.00 460.00 396.00 456.00 416.00 456.00 436.00 456.00 * 1 1 5 dname VECTOR 416.00 452.00 416.00 436.00 * 5 0 0 CENTCENT 416.00 416.00 397.00 412.00 416.00 412.00 435.00 412.00 * 1 1 4 DEPT VECTOR 472.00 492.00 476.00 472.00 * 5 0 0 CENTCENT 476.00 468.00 464.00 464.00 476.00 464.00 489.00 464.00 * 1 1 4 sort CENTCENT 476.00 460.00 462.00 456.00 476.00 456.00 490.00 456.00 * 1 1 4 dept VECTOR 476.00 452.00 476.00 432.00 * 5 0 0 CENTCENT 476.00 428.00 463.00 424.00 476.00 424.00 490.00 424.00 * 1 1 4 scan CENTCENT 476.00 416.00 461.00 412.00 476.00 412.00 491.00 412.00 * 1 1 3 EMP CENTCENT 448.00 500.00 409.00 496.00 448.00 496.00 488.00 496.00 * 1 1 12 Join - dname CENTCENT 284.00 428.00 254.00 424.00 284.00 424.00 314.00 424.00 * 1 1 9 indexscan CENTCENT 320.00 180.00 290.00 176.00 320.00 176.00 350.00 176.00 * 1 1 9 indexscan VECTOR 312.00 204.00 320.00 188.00 * 5 0 0 CENTCENT 264.00 180.00 251.00 176.00 264.00 176.00 278.00 176.00 * 1 1 4 scan VECTOR 284.00 204.00 276.00 188.00 * 5 0 0 CENTCENT 300.00 212.00 291.00 208.00 300.00 208.00 310.00 208.00 * 1 1 2 NL CENTCENT 264.00 168.00 245.00 164.00 264.00 164.00 283.00 164.00 * 1 1 4 DEPT CENTCENT 320.00 168.00 305.00 164.00 320.00 164.00 335.00 164.00 * 1 1 3 EMP CENTCENT 316.00 132.00 297.00 128.00 316.00 128.00 335.00 128.00 * 1 1 6 (dept) CENTCENT 460.00 212.00 432.00 208.00 460.00 208.00 489.00 208.00 * 1 1 10 Join - tid CENTCENT 484.00 192.00 471.00 188.00 484.00 188.00 498.00 188.00 * 1 1 4 scan CENTCENT 484.00 180.00 469.00 176.00 484.00 176.00 499.00 176.00 * 1 1 3 EMP VECTOR 472.00 204.00 480.00 196.00 * 5 0 0 CENTCENT 420.00 188.00 408.00 184.00 420.00 184.00 433.00 184.00 * 1 1 4 sort CENTCENT 420.00 176.00 407.00 172.00 420.00 172.00 433.00 172.00 * 1 1 4 tidp VECTOR 416.00 168.00 416.00 156.00 * 5 0 0 CENTCENT 416.00 148.00 377.00 144.00 416.00 144.00 456.00 144.00 * 1 1 12 Join - dname CENTCENT 372.00 120.00 342.00 116.00 372.00 116.00 402.00 116.00 * 1 1 9 indexscan CENTCENT 368.00 96.00 349.00 92.00 368.00 92.00 387.00 92.00 * 1 1 6 (dept) CENTCENT 448.00 124.00 436.00 120.00 448.00 120.00 461.00 120.00 * 1 1 4 sort CENTCENT 448.00 112.00 428.00 108.00 448.00 108.00 468.00 108.00 * 1 1 5 dname VECTOR 448.00 104.00 448.00 88.00 * 5 0 0 VECTOR 428.00 204.00 420.00 196.00 * 5 0 0 VECTOR 436.00 140.00 448.00 128.00 * 5 0 0 CENTCENT 448.00 84.00 435.00 80.00 448.00 80.00 462.00 80.00 * 1 1 4 scan CENTCENT 448.00 72.00 429.00 68.00 448.00 68.00 467.00 68.00 * 1 1 4 DEPT CENTCENT 108.00 136.00 99.00 132.00 108.00 132.00 118.00 132.00 * 3 1 3 (e) VECTOR 4.00 124.00 240.00 124.00 * 6 0 0 CENTCENT 72.00 32.00 47.00 28.00 72.00 28.00 97.00 28.00 * 1 1 7 (dname) CENTCENT 76.00 80.00 46.00 76.00 76.00 76.00 106.00 76.00 * 1 1 9 indexscan CENTCENT 76.00 68.00 57.00 64.00 76.00 64.00 95.00 64.00 * 1 1 4 DEPT VECTOR 68.00 104.00 76.00 88.00 * 5 0 0 CENTCENT 20.00 68.00 5.00 64.00 20.00 64.00 35.00 64.00 * 1 1 3 EMP CENTCENT 20.00 80.00 7.00 76.00 20.00 76.00 34.00 76.00 * 1 1 4 scan VECTOR 40.00 104.00 32.00 88.00 * 5 0 0 CENTCENT 56.00 112.00 47.00 108.00 56.00 108.00 66.00 108.00 * 1 1 2 NL CENTCENT 152.00 56.00 133.00 52.00 152.00 52.00 172.00 52.00 * 1 1 7 (floor) CENTCENT 156.00 80.00 126.00 76.00 156.00 76.00 186.00 76.00 * 1 1 9 indexscan CENTCENT 156.00 68.00 137.00 64.00 156.00 64.00 175.00 64.00 * 1 1 4 DEPT VECTOR 204.00 104.00 216.00 96.00 * 5 0 0 CENTCENT 216.00 40.00 201.00 36.00 216.00 36.00 231.00 36.00 * 1 1 3 EMP CENTCENT 216.00 52.00 203.00 48.00 216.00 48.00 230.00 48.00 * 1 1 4 scan VECTOR 216.00 68.00 216.00 56.00 * 5 0 0 CENTCENT 216.00 80.00 202.00 76.00 216.00 76.00 230.00 76.00 * 1 1 4 dept CENTCENT 216.00 92.00 204.00 88.00 216.00 88.00 229.00 88.00 * 1 1 4 sort VECTOR 164.00 104.00 156.00 88.00 * 5 0 0 CENTCENT 188.00 112.00 149.00 108.00 188.00 108.00 228.00 108.00 * 1 1 12 Join - dname CENTCENT 108.00 24.00 98.00 20.00 108.00 20.00 118.00 20.00 * 3 1 3 (g) CENTCENT 72.00 188.00 56.00 184.00 72.00 184.00 89.00 184.00 * 1 1 5 using CENTCENT 72.00 176.00 31.00 172.00 72.00 172.00 114.00 172.00 * 1 1 9 DEPTINDEX CENTCENT 72.00 56.00 56.00 52.00 72.00 52.00 89.00 52.00 * 1 1 5 using CENTCENT 76.00 44.00 35.00 40.00 76.00 40.00 118.00 40.00 * 1 1 9 DEPTINDEX CENTCENT 320.00 156.00 304.00 152.00 320.00 152.00 337.00 152.00 * 1 1 5 using CENTCENT 320.00 144.00 283.00 140.00 320.00 140.00 358.00 140.00 * 1 1 8 EMPINDEX CENTCENT 368.00 108.00 331.00 104.00 368.00 104.00 406.00 104.00 * 1 1 8 EMPINDEX -1