iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4289.875 | | σ | 1982.843 | | min | 1548.000 | | max | 7212.000 |
| | mean | 105.899 | | σ | 263.631 | | min | 12.403 | | max | 758.352 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4289.875 | | σ | 1982.843 | | min | 1548.000 | | max | 7212.000 |
| | mean | 13.755 | | σ | 3.136 | | min | 11.755 | | max | 21.354 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7212.000 | | σ | 0.000 | | min | 7212.000 | | max | 7212.000 |
| | mean | 14.830 | | σ | 0.778 | | min | 13.298 | | max | 15.316 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7212.000 | | σ | 0.000 | | min | 7212.000 | | max | 7212.000 |
| | mean | 13.574 | | σ | 0.909 | | min | 11.895 | | max | 14.362 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4173.000 | | σ | 1904.988 | | min | 1548.000 | | max | 7212.000 |
| | mean | 13.089 | | σ | 1.223 | | min | 10.975 | | max | 14.231 |
|
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 | 4173.000 | | σ | 1904.988 | | min | 1548.000 | | max | 7212.000 |
| | mean | 9.154 | | σ | 0.416 | | min | 8.443 | | max | 9.539 |
|
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 | 4173.000 | | σ | 1904.988 | | min | 1548.000 | | max | 7212.000 |
| | mean | 7.157 | | σ | 0.299 | | min | 6.552 | | max | 7.418 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.664 | | max | 25.668 |
| | mean | 4289.875 | | σ | 1982.843 | | min | 1548.000 | | max | 7212.000 |
| | mean | 6.295 | | σ | 0.621 | | min | 5.936 | | max | 7.811 |
|
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.875 | | σ | 1982.843 | | min | 1548.000 | | max | 7212.000 |
| | mean | 5.894 | | σ | 0.583 | | min | 5.580 | | max | 7.324 |
|
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 | 4289.875 | | σ | 1982.843 | | min | 1548.000 | | max | 7212.000 |
| | mean | 5.930 | | σ | 0.633 | | min | 5.602 | | max | 7.491 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4289.875 | | σ | 1982.843 | | min | 1548.000 | | max | 7212.000 |
| | mean | 5.783 | | σ | 0.640 | | min | 5.513 | | max | 7.366 |
|
op=column_set() on indexed | | mean | 36.605 | | σ | 0.000 | | min | 36.605 | | max | 36.605 |
| | mean | 4427.125 | | σ | 2230.102 | | min | 1484.000 | | max | 7413.000 |
| | mean | 13.622 | | σ | 3.564 | | min | 12.045 | | max | 22.405 |
|
op=column_set() on indexed, repeat | | mean | 36.605 | | σ | 0.000 | | min | 36.605 | | max | 36.606 |
| | mean | 4608.625 | | σ | 2261.333 | | min | 1484.000 | | max | 7413.000 |
| | mean | 148.270 | | σ | 380.389 | | min | 11.666 | | max | 1089.639 |
|
op=table_records(), no indexes | | mean | 41.940 | | σ | 0.002 | | min | 41.938 | | max | 41.943 |
| | mean | 7413.000 | | σ | 0.000 | | min | 7413.000 | | max | 7413.000 |
| | mean | 11.468 | | σ | 0.295 | | min | 11.097 | | max | 12.041 |
|
op=table_records(), repeat | | mean | 41.925 | | σ | 0.000 | | min | 41.925 | | max | 41.925 |
| | mean | 4198.250 | | σ | 1957.137 | | min | 1484.000 | | max | 7413.000 |
| | mean | 11.668 | | σ | 0.972 | | min | 10.874 | | max | 14.002 |
|
op=vertical_lookup_list() on indexed, after table_records() | | mean | 27.634 | | σ | 0.137 | | min | 27.585 | | max | 27.972 |
| | mean | 4198.250 | | σ | 1957.137 | | min | 1484.000 | | max | 7413.000 |
| | mean | 8.839 | | σ | 0.455 | | min | 8.275 | | max | 9.713 |
|
op=vertical_lookup_list() on indexed, after table_records(), repeat | | mean | 26.385 | | σ | 0.000 | | min | 26.385 | | max | 26.385 |
| | mean | 4198.250 | | σ | 1957.137 | | min | 1484.000 | | max | 7413.000 |
| | mean | 6.390 | | σ | 0.678 | | min | 5.351 | | max | 7.752 |
|
op=vertical_lookup_row_list() on 2 indexed | | mean | 25.663 | | σ | 0.004 | | min | 25.662 | | max | 25.674 |
| | mean | 4608.625 | | σ | 2261.333 | | min | 1484.000 | | max | 7413.000 |
| | mean | 6.659 | | σ | 1.238 | | min | 5.820 | | max | 8.849 |
|
op=vertical_lookup_row_list() on 3 (1 unindexed) | | mean | 25.962 | | σ | 0.001 | | min | 25.962 | | max | 25.964 |
| | mean | 4608.625 | | σ | 2261.333 | | min | 1484.000 | | max | 7413.000 |
| | mean | 6.532 | | σ | 1.210 | | min | 5.783 | | max | 8.958 |
|