iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4169.375 | | σ | 1898.642 | | min | 1551.000 | | max | 7200.000 |
| | mean | 12.663 | | σ | 0.346 | | min | 12.361 | | max | 13.229 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4289.750 | | σ | 1978.683 | | min | 1551.000 | | max | 7200.000 |
| | mean | 98.041 | | σ | 242.618 | | min | 11.984 | | max | 698.491 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7200.000 | | σ | 0.000 | | min | 7200.000 | | max | 7200.000 |
| | mean | 14.879 | | σ | 1.432 | | min | 11.786 | | max | 16.083 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7200.000 | | σ | 0.000 | | min | 7200.000 | | max | 7200.000 |
| | mean | 14.374 | | σ | 1.445 | | min | 11.161 | | max | 15.600 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4169.375 | | σ | 1898.642 | | min | 1551.000 | | max | 7200.000 |
| | mean | 13.677 | | σ | 1.541 | | min | 11.008 | | max | 15.273 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605 | | σ | 0.002 | | min | 27.603 | | max | 27.607 |
| | mean | 4169.375 | | σ | 1898.642 | | min | 1551.000 | | max | 7200.000 |
| | mean | 9.222 | | σ | 0.350 | | min | 8.719 | | max | 9.667 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400 | | σ | 0.002 | | min | 26.399 | | max | 26.403 |
| | mean | 4169.375 | | σ | 1898.642 | | min | 1551.000 | | max | 7200.000 |
| | mean | 6.673 | | σ | 0.324 | | min | 6.329 | | max | 7.213 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.664 | | max | 25.670 |
| | mean | 4289.750 | | σ | 1978.683 | | min | 1551.000 | | max | 7200.000 |
| | mean | 6.150 | | σ | 0.627 | | min | 5.682 | | max | 7.654 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.661 | | σ | 0.002 | | min | 25.659 | | max | 25.663 |
| | mean | 4289.750 | | σ | 1978.683 | | min | 1551.000 | | max | 7200.000 |
| | mean | 5.732 | | σ | 0.497 | | min | 5.110 | | max | 6.859 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969 | | σ | 0.002 | | min | 25.967 | | max | 25.972 |
| | mean | 4289.750 | | σ | 1978.683 | | min | 1551.000 | | max | 7200.000 |
| | mean | 5.802 | | σ | 0.542 | | min | 5.169 | | max | 7.033 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.969 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4289.750 | | σ | 1978.683 | | min | 1551.000 | | max | 7200.000 |
| | mean | 5.757 | | σ | 0.403 | | min | 5.399 | | max | 6.705 |
|