Complete Linux

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

/ Complete Linux / Complete Linux.iso / docs / apps / database / postgres / postgre2.z / postgre2 / doc / implementation / planner / table5.3 < prev

Wrap

Text File | 1992-08-27 | 7.8 KB | 863 lines

sungremlinfile 0 452.00 504.00 VECTOR 452.00 504.00 452.00 44.00 * 5 0 0 VECTOR 268.00 504.00 268.00 44.00 * 5 0 0 VECTOR 84.00 504.00 84.00 44.00 * 5 0 0 VECTOR 8.00 504.00 8.00 44.00 500.00 44.00 500.00 504.00 8.00 504.00 * 5 0 0 CENTCENT 420.00 120.00 394.00 116.00 420.00 116.00 447.00 116.00 * 1 1 5 WATER CENTCENT 420.00 132.00 407.00 128.00 420.00 128.00 434.00 128.00 * 1 1 4 scan VECTOR 420.00 156.00 420.00 140.00 * 5 0 0 VECTOR 412.00 200.00 420.00 184.00 * 5 0 0 CENTCENT 420.00 164.00 406.00 160.00 420.00 160.00 435.00 160.00 * 1 1 5 floor CENTCENT 420.00 176.00 408.00 172.00 420.00 172.00 433.00 172.00 * 1 1 4 sort CENTCENT 348.00 108.00 329.00 104.00 348.00 104.00 368.00 104.00 * 1 1 7 (floor) CENTCENT 312.00 196.00 275.00 192.00 312.00 192.00 350.00 192.00 * 1 1 8 EMPINDEX CENTCENT 348.00 120.00 329.00 116.00 348.00 116.00 367.00 116.00 * 1 1 4 DEPT CENTCENT 352.00 132.00 322.00 128.00 352.00 128.00 382.00 128.00 * 1 1 9 indexscan VECTOR 352.00 156.00 352.00 140.00 * 5 0 0 VECTOR 368.00 200.00 356.00 180.00 * 5 0 0 CENTCENT 356.00 164.00 336.00 160.00 356.00 160.00 376.00 160.00 * 1 1 5 dname CENTCENT 356.00 176.00 344.00 172.00 356.00 172.00 369.00 172.00 * 1 1 4 sort VECTOR 380.00 236.00 396.00 216.00 * 5 0 0 CENTCENT 392.00 208.00 358.00 204.00 392.00 204.00 426.00 204.00 * 1 1 12 Join - floor VECTOR 328.00 236.00 308.00 216.00 * 5 0 0 CENTCENT 308.00 184.00 289.00 180.00 308.00 180.00 327.00 180.00 * 1 1 6 (dept) CENTCENT 308.00 208.00 278.00 204.00 308.00 204.00 338.00 204.00 * 1 1 9 indexscan CENTCENT 352.00 244.00 313.00 240.00 352.00 240.00 392.00 240.00 * 1 1 12 Join - dname CENTCENT 476.00 148.00 467.00 144.00 476.00 144.00 485.00 144.00 * 1 1 3 3.4 CENTCENT 120.00 112.00 101.00 108.00 120.00 108.00 139.00 108.00 * 1 1 4 DEPT CENTCENT 224.00 168.00 182.00 164.00 224.00 164.00 266.00 164.00 * 1 1 10 scan WATER CENTCENT 176.00 240.00 145.00 236.00 176.00 236.00 207.00 236.00 * 1 1 10 MS - floor CENTCENT 220.00 204.00 191.00 200.00 220.00 200.00 249.00 200.00 * 1 1 10 sort floor CENTCENT 192.00 100.00 173.00 96.00 192.00 96.00 211.00 96.00 * 1 1 6 (dept) CENTCENT 192.00 112.00 177.00 108.00 192.00 108.00 207.00 108.00 * 1 1 3 EMP CENTCENT 132.00 204.00 103.00 200.00 132.00 200.00 161.00 200.00 * 1 1 10 sort floor CENTCENT 44.00 148.00 33.00 144.00 44.00 144.00 55.00 144.00 * 2 1 3 and CENTCENT 44.00 168.00 30.00 164.00 44.00 164.00 59.00 164.00 * 1 1 5 floor CENTCENT 44.00 180.00 25.00 176.00 44.00 176.00 63.00 176.00 * 1 1 4 DEPT CENTCENT 44.00 192.00 37.00 188.00 44.00 188.00 52.00 188.00 * 1 1 2 on CENTCENT 44.00 204.00 28.00 200.00 44.00 200.00 61.00 200.00 * 1 1 5 index CENTCENT 44.00 220.00 20.00 216.00 44.00 216.00 69.00 216.00 * 1 1 7 primary CENTCENT 44.00 64.00 30.00 60.00 44.00 60.00 58.00 60.00 * 1 1 4 dept CENTCENT 44.00 80.00 29.00 76.00 44.00 76.00 59.00 76.00 * 1 1 3 EMP CENTCENT 44.00 96.00 37.00 92.00 44.00 92.00 52.00 92.00 * 1 1 2 on CENTCENT 44.00 108.00 28.00 104.00 44.00 104.00 61.00 104.00 * 1 1 5 index CENTCENT 44.00 124.00 14.00 120.00 44.00 120.00 75.00 120.00 * 1 1 9 secondary CENTCENT 400.00 272.00 366.00 268.00 400.00 268.00 435.00 268.00 * 1 1 9 scan DEPT VECTOR 400.00 292.00 400.00 280.00 * 5 0 0 VECTOR 384.00 320.00 396.00 308.00 * 5 0 0 CENTCENT 396.00 300.00 362.00 296.00 396.00 296.00 431.00 296.00 * 1 1 10 sort dname VECTOR 320.00 320.00 304.00 308.00 * 5 0 0 CENTCENT 304.00 276.00 285.00 272.00 304.00 272.00 323.00 272.00 * 1 1 6 (dept) CENTCENT 312.00 288.00 275.00 284.00 312.00 284.00 350.00 284.00 * 1 1 8 EMPINDEX CENTCENT 308.00 300.00 278.00 296.00 308.00 296.00 338.00 296.00 * 1 1 9 indexscan VECTOR 420.00 384.00 424.00 376.00 * 5 0 0 CENTCENT 424.00 356.00 409.00 352.00 424.00 352.00 439.00 352.00 * 1 1 3 EMP CENTCENT 424.00 368.00 411.00 364.00 424.00 364.00 438.00 364.00 * 1 1 4 scan CENTCENT 356.00 328.00 317.00 324.00 356.00 324.00 396.00 324.00 * 1 1 12 Join - dname VECTOR 396.00 444.00 404.00 432.00 * 5 0 0 VECTOR 356.00 344.00 356.00 336.00 * 5 0 0 VECTOR 380.00 384.00 360.00 376.00 * 5 0 0 CENTCENT 360.00 356.00 347.00 352.00 360.00 352.00 373.00 352.00 * 1 1 4 tidp CENTCENT 360.00 368.00 348.00 364.00 360.00 364.00 373.00 364.00 * 1 1 4 sort CENTCENT 404.00 392.00 376.00 388.00 404.00 388.00 433.00 388.00 * 1 1 10 Join - tid VECTOR 404.00 416.00 404.00 400.00 * 5 0 0 CENTCENT 404.00 424.00 375.00 420.00 404.00 420.00 433.00 420.00 * 1 1 10 sort floor CENTCENT 304.00 356.00 278.00 352.00 304.00 352.00 331.00 352.00 * 1 1 5 WATER CENTCENT 304.00 368.00 291.00 364.00 304.00 364.00 318.00 364.00 * 1 1 4 scan VECTOR 304.00 392.00 304.00 380.00 * 5 0 0 VECTOR 336.00 444.00 304.00 424.00 * 5 0 0 CENTCENT 304.00 404.00 290.00 400.00 304.00 400.00 319.00 400.00 * 1 1 5 floor CENTCENT 304.00 416.00 292.00 412.00 304.00 412.00 317.00 412.00 * 1 1 4 sort CENTCENT 364.00 452.00 325.00 448.00 364.00 448.00 404.00 448.00 * 1 1 12 Join - dname CENTCENT 476.00 376.00 466.00 372.00 476.00 372.00 487.00 372.00 * 1 1 3 487 CENTCENT 44.00 340.00 30.00 336.00 44.00 336.00 58.00 336.00 * 1 1 4 dept CENTCENT 44.00 356.00 29.00 352.00 44.00 352.00 59.00 352.00 * 1 1 3 EMP CENTCENT 44.00 372.00 37.00 368.00 44.00 368.00 52.00 368.00 * 1 1 2 on CENTCENT 44.00 384.00 28.00 380.00 44.00 380.00 61.00 380.00 * 1 1 5 index CENTCENT 44.00 400.00 14.00 396.00 44.00 396.00 75.00 396.00 * 1 1 9 secondary VECTOR 124.00 196.00 124.00 160.00 * 5 0 0 VECTOR 140.00 144.00 192.00 132.00 * 5 0 0 CENTCENT 196.00 124.00 166.00 120.00 196.00 120.00 226.00 120.00 * 1 1 9 indexscan VECTOR 124.00 144.00 116.00 128.00 * 5 0 0 VECTOR 224.00 192.00 224.00 176.00 * 5 0 0 VECTOR 200.00 232.00 220.00 212.00 * 5 0 0 CENTCENT 120.00 124.00 107.00 120.00 120.00 120.00 134.00 120.00 * 1 1 4 scan CENTCENT 128.00 152.00 119.00 148.00 128.00 148.00 138.00 148.00 * 1 1 2 NL VECTOR 152.00 232.00 132.00 212.00 * 5 0 0 CENTCENT 176.00 292.00 157.00 288.00 176.00 288.00 195.00 288.00 * 1 1 4 DEPT CENTCENT 176.00 304.00 163.00 300.00 176.00 300.00 190.00 300.00 * 1 1 4 scan VECTOR 176.00 324.00 176.00 312.00 * 5 0 0 CENTCENT 176.00 336.00 162.00 332.00 176.00 332.00 191.00 332.00 * 1 1 5 floor CENTCENT 176.00 348.00 164.00 344.00 176.00 344.00 189.00 344.00 * 1 1 4 sort VECTOR 164.00 376.00 172.00 352.00 * 5 0 0 CENTCENT 220.00 384.00 190.00 380.00 220.00 380.00 251.00 380.00 * 1 1 8 scan EMP VECTOR 220.00 404.00 220.00 392.00 * 5 0 0 VECTOR 200.00 440.00 216.00 424.00 * 5 0 0 CENTCENT 220.00 416.00 192.00 412.00 220.00 412.00 249.00 412.00 * 1 1 9 sort dept CENTCENT 116.00 292.00 90.00 288.00 116.00 288.00 143.00 288.00 * 1 1 5 WATER CENTCENT 112.00 304.00 99.00 300.00 112.00 300.00 126.00 300.00 * 1 1 4 scan VECTOR 112.00 324.00 112.00 312.00 * 5 0 0 VECTOR 116.00 376.00 112.00 356.00 * 5 0 0 CENTCENT 112.00 336.00 98.00 332.00 112.00 332.00 127.00 332.00 * 1 1 5 floor CENTCENT 112.00 348.00 100.00 344.00 112.00 344.00 125.00 344.00 * 1 1 4 sort CENTCENT 132.00 384.00 101.00 380.00 132.00 380.00 163.00 380.00 * 1 1 10 MS - floor VECTOR 132.00 404.00 132.00 392.00 * 5 0 0 CENTCENT 136.00 416.00 102.00 412.00 136.00 412.00 171.00 412.00 * 1 1 10 sort dname VECTOR 152.00 440.00 136.00 424.00 * 5 0 0 CENTCENT 176.00 452.00 146.00 448.00 176.00 448.00 207.00 448.00 * 1 1 9 MS - dept CENTCENT 364.00 484.00 337.00 480.00 364.00 480.00 391.00 480.00 * 1 1 6 INGRES CENTCENT 180.00 484.00 142.00 480.00 180.00 480.00 218.00 480.00 * 1 1 8 POSTGRES CENTCENT 472.00 488.00 466.00 484.00 472.00 484.00 479.00 484.00 * 1 1 1 % CENTCENT 476.00 476.00 463.00 472.00 476.00 472.00 489.00 472.00 * 1 1 5 diff. VECTOR 8.00 256.00 500.00 256.00 * 5 0 0 VECTOR 8.00 464.00 500.00 464.00 * 5 0 0 CENTCENT 44.00 476.00 15.00 472.00 44.00 472.00 73.00 472.00 * 1 1 9 structure TOPLEFT 24.00 496.00 24.00 487.00 46.00 487.00 69.00 487.00 * 1 1 7 storage CENTCENT 44.00 416.00 34.00 412.00 44.00 412.00 54.00 412.00 * 3 1 3 (3) CENTCENT 44.00 236.00 34.00 232.00 44.00 232.00 54.00 232.00 * 3 1 3 (4) -1