iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4161.250 | | σ | 1889.755 | | min | 1545.000 | | max | 7170.000 |
| | mean | 12.791 | | σ | 0.362 | | min | 12.419 | | max | 13.471 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.619 |
| | mean | 4278.375 | | σ | 1967.808 | | min | 1545.000 | | max | 7170.000 |
| | mean | 13.189 | | σ | 1.958 | | min | 11.922 | | max | 17.862 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7170.000 | | σ | 0.000 | | min | 7170.000 | | max | 7170.000 |
| | mean | 15.061 | | σ | 0.668 | | min | 13.977 | | max | 15.684 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7170.000 | | σ | 0.000 | | min | 7170.000 | | max | 7170.000 |
| | mean | 12.867 | | σ | 0.990 | | min | 11.695 | | max | 14.421 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4161.250 | | σ | 1889.755 | | min | 1545.000 | | max | 7170.000 |
| | mean | 13.219 | | σ | 1.742 | | min | 10.711 | | max | 15.473 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605 | | σ | 0.003 | | min | 27.603 | | max | 27.611 |
| | mean | 4161.250 | | σ | 1889.755 | | min | 1545.000 | | max | 7170.000 |
| | mean | 9.037 | | σ | 0.381 | | min | 8.283 | | max | 9.476 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400 | | σ | 0.001 | | min | 26.399 | | max | 26.403 |
| | mean | 4161.250 | | σ | 1889.755 | | min | 1545.000 | | max | 7170.000 |
| | mean | 6.917 | | σ | 0.292 | | min | 6.468 | | max | 7.375 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.667 | | σ | 0.002 | | min | 25.665 | | max | 25.670 |
| | mean | 4278.375 | | σ | 1967.808 | | min | 1545.000 | | max | 7170.000 |
| | mean | 6.325 | | σ | 0.583 | | min | 6.040 | | max | 7.756 |
|
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 | 4278.375 | | σ | 1967.808 | | min | 1545.000 | | max | 7170.000 |
| | mean | 5.888 | | σ | 0.440 | | min | 5.647 | | max | 6.951 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4278.375 | | σ | 1967.808 | | min | 1545.000 | | max | 7170.000 |
| | mean | 5.990 | | σ | 0.364 | | min | 5.757 | | max | 6.848 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968 | | σ | 0.001 | | min | 25.967 | | max | 25.971 |
| | mean | 4278.375 | | σ | 1967.808 | | min | 1545.000 | | max | 7170.000 |
| | mean | 5.810 | | σ | 0.337 | | min | 5.586 | | max | 6.616 |
|