Compare Query Plans

Comparing the query plans of two OLTP-SET benchmarks: A and B.

  • A benchmarked commit 6076fed using the Gen4 query planner.
  • B benchmarked commit bedcf51 using the Gen4 query planner.

Queries are ordered from the slowest to the fastest. The 50 slowest queries are shown.

select distinct c from sbtest6 where id between :vtg1 and :vtg2 order by c asc
Only A
select distinct c from sbtest7 where id between :vtg1 and :vtg2 order by c asc
Only A
select distinct c from sbtest1 where id between :vtg1 and :vtg2 order by c asc
Only A
select distinct c from sbtest10 where id between :vtg1 and :vtg2 order by c asc
Only A
select distinct c from sbtest3 where id between :vtg1 and :vtg2 order by c asc
Only A
select distinct c from sbtest2 where id between :vtg1 and :vtg2 order by c asc
Only A
select distinct c from sbtest9 where id between :vtg1 and :vtg2 order by c asc
Only A
select distinct c from sbtest4 where id between :vtg1 and :vtg2 order by c asc
Only A
select distinct c from sbtest5 where id between :vtg1 and :vtg2 order by c asc
Only A
select distinct c from sbtest8 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest4 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest8 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest3 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest5 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest6 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest1 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest10 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest2 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest9 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest7 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest4 where id between :vtg1 and :vtg2
Only A
select c from sbtest2 where id between :vtg1 and :vtg2
Only A
select c from sbtest5 where id between :vtg1 and :vtg2
Only A
select c from sbtest3 where id between :vtg1 and :vtg2
Only A
select c from sbtest1 where id between :vtg1 and :vtg2
Only A
select c from sbtest10 where id between :vtg1 and :vtg2
Only A
select c from sbtest9 where id between :vtg1 and :vtg2
Only A
select c from sbtest7 where id between :vtg1 and :vtg2
Only A
select c from sbtest6 where id between :vtg1 and :vtg2
Only A
select c from sbtest8 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest9 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest6 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest3 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest1 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest8 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest10 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest5 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest7 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest4 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest2 where id between :vtg1 and :vtg2
Only A
select c from sbtest1 where id = :id
Only A
select c from sbtest6 where id = :id
Only A
select c from sbtest4 where id = :id
Only A
select c from sbtest2 where id = :id
Only A
select c from sbtest10 where id = :id
Only A
select c from sbtest3 where id = :id
Only A
select c from sbtest9 where id = :id
Only A
select c from sbtest8 where id = :id
Only A
select c from sbtest5 where id = :id
Only A
select c from sbtest7 where id = :id
Only A
select distinct c from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest3 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest4 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest7 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest6 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest6 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest4 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest7 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest3 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest4 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest3 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest6 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest7 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest7 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest6 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest3 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest4 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest10 where id = :id /* INT64 */
Only B
select c from sbtest6 where id = :id /* INT64 */
Only B
select c from sbtest8 where id = :id /* INT64 */
Only B
select c from sbtest7 where id = :id /* INT64 */
Only B
select c from sbtest5 where id = :id /* INT64 */
Only B
select c from sbtest2 where id = :id /* INT64 */
Only B
select c from sbtest9 where id = :id /* INT64 */
Only B
select c from sbtest1 where id = :id /* INT64 */
Only B
select c from sbtest3 where id = :id /* INT64 */
Only B
select c from sbtest4 where id = :id /* INT64 */
Only B
Statistics
Query select distinct c from sbtest6 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80790 N/A 0%
Execution Time 2027549 N/A 0%
Rows Returned 8035505 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "GroupBy": "(0|1) COLLATE utf8mb4_0900_ai_ci", "Inputs": [ { "FieldQuery": "select c, weight_string(c) from sbtest6 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci, 0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select distinct c, weight_string(c) from sbtest6 where id between :vtg1 and :vtg2 order by c asc, c asc", "Table": "sbtest6", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "ResultColumns": 1, "Variant": "Ordered" }
Statistics
Query select distinct c from sbtest7 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80554 N/A 0%
Execution Time 2025522 N/A 0%
Rows Returned 8016815 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "GroupBy": "(0|1) COLLATE utf8mb4_0900_ai_ci", "Inputs": [ { "FieldQuery": "select c, weight_string(c) from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci, 0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select distinct c, weight_string(c) from sbtest7 where id between :vtg1 and :vtg2 order by c asc, c asc", "Table": "sbtest7", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "ResultColumns": 1, "Variant": "Ordered" }
Statistics
Query select distinct c from sbtest1 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80289 N/A 0%
Execution Time 2025516 N/A 0%
Rows Returned 7987751 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "GroupBy": "(0|1) COLLATE utf8mb4_0900_ai_ci", "Inputs": [ { "FieldQuery": "select c, weight_string(c) from sbtest1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci, 0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select distinct c, weight_string(c) from sbtest1 where id between :vtg1 and :vtg2 order by c asc, c asc", "Table": "sbtest1", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "ResultColumns": 1, "Variant": "Ordered" }
Statistics
Query select distinct c from sbtest10 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80398 N/A 0%
Execution Time 2024608 N/A 0%
Rows Returned 7998100 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "GroupBy": "(0|1) COLLATE utf8mb4_0900_ai_ci", "Inputs": [ { "FieldQuery": "select c, weight_string(c) from sbtest10 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci, 0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select distinct c, weight_string(c) from sbtest10 where id between :vtg1 and :vtg2 order by c asc, c asc", "Table": "sbtest10", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "ResultColumns": 1, "Variant": "Ordered" }
Statistics
Query select distinct c from sbtest3 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80307 N/A 0%
Execution Time 2023770 N/A 0%
Rows Returned 7989112 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "GroupBy": "(0|1) COLLATE utf8mb4_0900_ai_ci", "Inputs": [ { "FieldQuery": "select c, weight_string(c) from sbtest3 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci, 0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select distinct c, weight_string(c) from sbtest3 where id between :vtg1 and :vtg2 order by c asc, c asc", "Table": "sbtest3", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "ResultColumns": 1, "Variant": "Ordered" }
Statistics
Query select distinct c from sbtest2 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80940 N/A 0%
Execution Time 2023589 N/A 0%
Rows Returned 8055136 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "GroupBy": "(0|1) COLLATE utf8mb4_0900_ai_ci", "Inputs": [ { "FieldQuery": "select c, weight_string(c) from sbtest2 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci, 0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select distinct c, weight_string(c) from sbtest2 where id between :vtg1 and :vtg2 order by c asc, c asc", "Table": "sbtest2", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "ResultColumns": 1, "Variant": "Ordered" }
Statistics
Query select distinct c from sbtest9 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80680 N/A 0%
Execution Time 2022141 N/A 0%
Rows Returned 8029936 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "GroupBy": "(0|1) COLLATE utf8mb4_0900_ai_ci", "Inputs": [ { "FieldQuery": "select c, weight_string(c) from sbtest9 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci, 0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select distinct c, weight_string(c) from sbtest9 where id between :vtg1 and :vtg2 order by c asc, c asc", "Table": "sbtest9", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "ResultColumns": 1, "Variant": "Ordered" }
Statistics
Query select distinct c from sbtest4 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80667 N/A 0%
Execution Time 2021987 N/A 0%
Rows Returned 8026411 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "GroupBy": "(0|1) COLLATE utf8mb4_0900_ai_ci", "Inputs": [ { "FieldQuery": "select c, weight_string(c) from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci, 0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select distinct c, weight_string(c) from sbtest4 where id between :vtg1 and :vtg2 order by c asc, c asc", "Table": "sbtest4", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "ResultColumns": 1, "Variant": "Ordered" }
Statistics
Query select distinct c from sbtest5 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80791 N/A 0%
Execution Time 2021945 N/A 0%
Rows Returned 8034567 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "GroupBy": "(0|1) COLLATE utf8mb4_0900_ai_ci", "Inputs": [ { "FieldQuery": "select c, weight_string(c) from sbtest5 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci, 0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select distinct c, weight_string(c) from sbtest5 where id between :vtg1 and :vtg2 order by c asc, c asc", "Table": "sbtest5", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "ResultColumns": 1, "Variant": "Ordered" }
Statistics
Query select distinct c from sbtest8 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80576 N/A 0%
Execution Time 2020762 N/A 0%
Rows Returned 8016991 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "GroupBy": "(0|1) COLLATE utf8mb4_0900_ai_ci", "Inputs": [ { "FieldQuery": "select c, weight_string(c) from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci, 0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select distinct c, weight_string(c) from sbtest8 where id between :vtg1 and :vtg2 order by c asc, c asc", "Table": "sbtest8", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "ResultColumns": 1, "Variant": "Ordered" }
Statistics
Query select c from sbtest4 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80444 N/A 0%
Execution Time 1601742 N/A 0%
Rows Returned 8004452 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select c from sbtest4 where id between :vtg1 and :vtg2 order by c asc", "Table": "sbtest4", "Variant": "Scatter" }
Statistics
Query select c from sbtest8 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80799 N/A 0%
Execution Time 1600912 N/A 0%
Rows Returned 8035860 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select c from sbtest8 where id between :vtg1 and :vtg2 order by c asc", "Table": "sbtest8", "Variant": "Scatter" }
Statistics
Query select c from sbtest3 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80462 N/A 0%
Execution Time 1600550 N/A 0%
Rows Returned 8007761 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest3 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select c from sbtest3 where id between :vtg1 and :vtg2 order by c asc", "Table": "sbtest3", "Variant": "Scatter" }
Statistics
Query select c from sbtest5 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80340 N/A 0%
Execution Time 1600110 N/A 0%
Rows Returned 7997503 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest5 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select c from sbtest5 where id between :vtg1 and :vtg2 order by c asc", "Table": "sbtest5", "Variant": "Scatter" }
Statistics
Query select c from sbtest6 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 81376 N/A 0%
Execution Time 1599669 N/A 0%
Rows Returned 8096358 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest6 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select c from sbtest6 where id between :vtg1 and :vtg2 order by c asc", "Table": "sbtest6", "Variant": "Scatter" }
Statistics
Query select c from sbtest1 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80766 N/A 0%
Execution Time 1599008 N/A 0%
Rows Returned 8035535 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select c from sbtest1 where id between :vtg1 and :vtg2 order by c asc", "Table": "sbtest1", "Variant": "Scatter" }
Statistics
Query select c from sbtest10 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80433 N/A 0%
Execution Time 1596863 N/A 0%
Rows Returned 8001558 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest10 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select c from sbtest10 where id between :vtg1 and :vtg2 order by c asc", "Table": "sbtest10", "Variant": "Scatter" }
Statistics
Query select c from sbtest2 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80347 N/A 0%
Execution Time 1596816 N/A 0%
Rows Returned 7993623 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest2 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select c from sbtest2 where id between :vtg1 and :vtg2 order by c asc", "Table": "sbtest2", "Variant": "Scatter" }
Statistics
Query select c from sbtest9 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80401 N/A 0%
Execution Time 1596125 N/A 0%
Rows Returned 8000048 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest9 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select c from sbtest9 where id between :vtg1 and :vtg2 order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest7 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 80623 N/A 0%
Execution Time 1595909 N/A 0%
Rows Returned 8020419 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select c from sbtest7 where id between :vtg1 and :vtg2 order by c asc", "Table": "sbtest7", "Variant": "Scatter" }
Statistics
Query select c from sbtest4 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80754 N/A 0%
Execution Time 1286715 N/A 0%
Rows Returned 8034053 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id between :vtg1 and :vtg2", "Table": "sbtest4", "Variant": "Scatter" }
Statistics
Query select c from sbtest2 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80478 N/A 0%
Execution Time 1283691 N/A 0%
Rows Returned 8010403 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest2 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest2 where id between :vtg1 and :vtg2", "Table": "sbtest2", "Variant": "Scatter" }
Statistics
Query select c from sbtest5 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80621 N/A 0%
Execution Time 1282438 N/A 0%
Rows Returned 8021257 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest5 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest5 where id between :vtg1 and :vtg2", "Table": "sbtest5", "Variant": "Scatter" }
Statistics
Query select c from sbtest3 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80355 N/A 0%
Execution Time 1280604 N/A 0%
Rows Returned 7995526 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest3 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest3 where id between :vtg1 and :vtg2", "Table": "sbtest3", "Variant": "Scatter" }
Statistics
Query select c from sbtest1 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80633 N/A 0%
Execution Time 1280292 N/A 0%
Rows Returned 8021989 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest1 where id between :vtg1 and :vtg2", "Table": "sbtest1", "Variant": "Scatter" }
Statistics
Query select c from sbtest10 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80199 N/A 0%
Execution Time 1278992 N/A 0%
Rows Returned 7981553 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest10 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest10 where id between :vtg1 and :vtg2", "Table": "sbtest10", "Variant": "Scatter" }
Statistics
Query select c from sbtest9 where id between :vtg1 and :vtg2
A B Diff
Execution Count 81003 N/A 0%
Execution Time 1278743 N/A 0%
Rows Returned 8060178 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest9 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest9 where id between :vtg1 and :vtg2", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest7 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80949 N/A 0%
Execution Time 1277996 N/A 0%
Rows Returned 8056990 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id between :vtg1 and :vtg2", "Table": "sbtest7", "Variant": "Scatter" }
Statistics
Query select c from sbtest6 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80357 N/A 0%
Execution Time 1276734 N/A 0%
Rows Returned 7996294 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest6 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest6 where id between :vtg1 and :vtg2", "Table": "sbtest6", "Variant": "Scatter" }
Statistics
Query select c from sbtest8 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80637 N/A 0%
Execution Time 1276326 N/A 0%
Rows Returned 8022819 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id between :vtg1 and :vtg2", "Table": "sbtest8", "Variant": "Scatter" }
Statistics
Query select sum(k) from sbtest9 where id between :vtg1 and :vtg2
A B Diff
Execution Count 81034 N/A 0%
Execution Time 1137500 N/A 0%
Rows Returned 81034 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest9 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest9 where id between :vtg1 and :vtg2", "Table": "sbtest9", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest6 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80805 N/A 0%
Execution Time 1137452 N/A 0%
Rows Returned 80805 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest6 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest6 where id between :vtg1 and :vtg2", "Table": "sbtest6", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest3 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80219 N/A 0%
Execution Time 1134733 N/A 0%
Rows Returned 80219 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest3 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest3 where id between :vtg1 and :vtg2", "Table": "sbtest3", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest1 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80458 N/A 0%
Execution Time 1134708 N/A 0%
Rows Returned 80458 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest1 where id between :vtg1 and :vtg2", "Table": "sbtest1", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest8 where id between :vtg1 and :vtg2
A B Diff
Execution Count 81078 N/A 0%
Execution Time 1134408 N/A 0%
Rows Returned 81078 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest8 where id between :vtg1 and :vtg2", "Table": "sbtest8", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest10 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80468 N/A 0%
Execution Time 1133381 N/A 0%
Rows Returned 80468 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest10 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest10 where id between :vtg1 and :vtg2", "Table": "sbtest10", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest5 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80439 N/A 0%
Execution Time 1132309 N/A 0%
Rows Returned 80439 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest5 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest5 where id between :vtg1 and :vtg2", "Table": "sbtest5", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest7 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80170 N/A 0%
Execution Time 1131940 N/A 0%
Rows Returned 80170 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest7 where id between :vtg1 and :vtg2", "Table": "sbtest7", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest4 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80588 N/A 0%
Execution Time 1131450 N/A 0%
Rows Returned 80588 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest4 where id between :vtg1 and :vtg2", "Table": "sbtest4", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest2 where id between :vtg1 and :vtg2
A B Diff
Execution Count 80733 N/A 0%
Execution Time 1128418 N/A 0%
Rows Returned 80733 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest2 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest2 where id between :vtg1 and :vtg2", "Table": "sbtest2", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select c from sbtest1 where id = :id
A B Diff
Execution Count 808833 N/A 0%
Execution Time 795252 N/A 0%
Rows Returned 808833 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest1 where id = :id", "Table": "sbtest1", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest6 where id = :id
A B Diff
Execution Count 810279 N/A 0%
Execution Time 795088 N/A 0%
Rows Returned 810279 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest6 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest6 where id = :id", "Table": "sbtest6", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest4 where id = :id
A B Diff
Execution Count 806515 N/A 0%
Execution Time 794986 N/A 0%
Rows Returned 806515 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest2 where id = :id
A B Diff
Execution Count 801196 N/A 0%
Execution Time 794651 N/A 0%
Rows Returned 801196 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest2 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest2 where id = :id", "Table": "sbtest2", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest10 where id = :id
A B Diff
Execution Count 808625 N/A 0%
Execution Time 794547 N/A 0%
Rows Returned 808625 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest10 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest10 where id = :id", "Table": "sbtest10", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest3 where id = :id
A B Diff
Execution Count 807245 N/A 0%
Execution Time 793968 N/A 0%
Rows Returned 807245 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest3 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest3 where id = :id", "Table": "sbtest3", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest9 where id = :id
A B Diff
Execution Count 800503 N/A 0%
Execution Time 793502 N/A 0%
Rows Returned 800503 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest9 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest9 where id = :id", "Table": "sbtest9", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest8 where id = :id
A B Diff
Execution Count 811710 N/A 0%
Execution Time 793191 N/A 0%
Rows Returned 811710 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id", "Table": "sbtest8", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest5 where id = :id
A B Diff
Execution Count 804175 N/A 0%
Execution Time 793137 N/A 0%
Rows Returned 804175 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest5 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest5 where id = :id", "Table": "sbtest5", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest7 where id = :id
A B Diff
Execution Count 800744 N/A 0%
Execution Time 792747 N/A 0%
Rows Returned 800744 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id", "Table": "sbtest7", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select distinct c from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select distinct c from sbtest3 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select distinct c from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select distinct c from sbtest4 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select distinct c from sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select distinct c from sbtest7 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select distinct c from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select distinct c from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select distinct c from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select distinct c from sbtest6 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest6 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest4 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest7 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest3 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest4 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest3 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest6 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest7 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(k) from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(k) from sbtest7 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(k) from sbtest6 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(k) from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(k) from sbtest3 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(k) from sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(k) from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(k) from sbtest4 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(k) from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(k) from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest10 where id = :id /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest6 where id = :id /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest8 where id = :id /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest7 where id = :id /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest5 where id = :id /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest2 where id = :id /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest9 where id = :id /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest1 where id = :id /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest3 where id = :id /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest4 where id = :id /* INT64 */
A B Diff
Execution Count N/A 815610 0%
Execution Time N/A 782520 0%
Rows Returned N/A 815610 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest4 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest4 where id = :id /* INT64 */", "Table": "sbtest4", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }