Compare Query Plans

Comparing the query plans of two OLTP 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 sbtest8 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 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 sbtest2 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 sbtest10 where id between :vtg1 and :vtg2 order by c asc
Only A
select distinct c from sbtest6 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 sbtest5 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 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 sbtest9 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 sbtest4 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 sbtest5 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 sbtest8 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest2 where id between :vtg1 and :vtg2
Only A
select c from sbtest4 where id between :vtg1 and :vtg2
Only A
select c from sbtest3 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 c from sbtest5 where id between :vtg1 and :vtg2
Only A
select c from sbtest7 where id between :vtg1 and :vtg2
Only A
select c from sbtest10 where id between :vtg1 and :vtg2
Only A
select c from sbtest1 where id between :vtg1 and :vtg2
Only A
select c from sbtest9 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 sbtest10 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest2 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 sbtest8 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 sbtest3 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 sbtest9 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest1 where id between :vtg1 and :vtg2
Only A
select c from sbtest3 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 sbtest9 where id = :id
Only A
select c from sbtest2 where id = :id
Only A
select c from sbtest4 where id = :id
Only A
select c from sbtest1 where id = :id
Only A
select c from sbtest10 where id = :id
Only A
select c from sbtest7 where id = :id
Only A
select c from sbtest6 where id = :id
Only A
select distinct c from sbtest10 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 sbtest3 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 sbtest1 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 distinct c from sbtest8 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 sbtest5 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 c from sbtest3 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 sbtest8 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 sbtest2 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 sbtest5 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 sbtest9 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 */
Only B
select c from sbtest5 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 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 sbtest8 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 c from sbtest1 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 sbtest1 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 sbtest5 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 sum(k) from sbtest6 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 sbtest3 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 sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest7 where id = :id /* INT64 */
Only B
select c from sbtest6 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 sbtest4 where id = :id /* INT64 */
Only B
select c from sbtest10 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 sbtest8 where id = :id /* INT64 */
Only B
Statistics
Query select distinct c from sbtest8 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 83983 N/A 0%
Execution Time 1843320 N/A 0%
Rows Returned 8354148 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 distinct c from sbtest7 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 83848 N/A 0%
Execution Time 1840548 N/A 0%
Rows Returned 8343554 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 sbtest9 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 83733 N/A 0%
Execution Time 1840479 N/A 0%
Rows Returned 8333008 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 83917 N/A 0%
Execution Time 1840454 N/A 0%
Rows Returned 8352573 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 sbtest2 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 84214 N/A 0%
Execution Time 1840103 N/A 0%
Rows Returned 8379460 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 sbtest3 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 83547 N/A 0%
Execution Time 1838960 N/A 0%
Rows Returned 8312420 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 sbtest10 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 83755 N/A 0%
Execution Time 1838237 N/A 0%
Rows Returned 8334602 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 sbtest6 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 84228 N/A 0%
Execution Time 1835924 N/A 0%
Rows Returned 8379150 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 sbtest1 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 83709 N/A 0%
Execution Time 1835207 N/A 0%
Rows Returned 8328436 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 sbtest5 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 84218 N/A 0%
Execution Time 1832018 N/A 0%
Rows Returned 8376330 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 c from sbtest7 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 84342 N/A 0%
Execution Time 1444445 N/A 0%
Rows Returned 8391781 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 sbtest1 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 83616 N/A 0%
Execution Time 1443348 N/A 0%
Rows Returned 8319977 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 83679 N/A 0%
Execution Time 1442839 N/A 0%
Rows Returned 8324378 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 sbtest9 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 84045 N/A 0%
Execution Time 1441255 N/A 0%
Rows Returned 8359376 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 sbtest3 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 83769 N/A 0%
Execution Time 1439770 N/A 0%
Rows Returned 8335227 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 sbtest4 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 84062 N/A 0%
Execution Time 1439255 N/A 0%
Rows Returned 8366703 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 sbtest6 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 83985 N/A 0%
Execution Time 1439174 N/A 0%
Rows Returned 8357108 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 sbtest5 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 83927 N/A 0%
Execution Time 1438139 N/A 0%
Rows Returned 8351464 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 sbtest2 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 83700 N/A 0%
Execution Time 1437831 N/A 0%
Rows Returned 8325836 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 sbtest8 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 84023 N/A 0%
Execution Time 1437305 N/A 0%
Rows Returned 8358760 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 sbtest2 where id between :vtg1 and :vtg2
A B Diff
Execution Count 83842 N/A 0%
Execution Time 1144769 N/A 0%
Rows Returned 8344057 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 sbtest4 where id between :vtg1 and :vtg2
A B Diff
Execution Count 84097 N/A 0%
Execution Time 1143430 N/A 0%
Rows Returned 8369419 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 sbtest3 where id between :vtg1 and :vtg2
A B Diff
Execution Count 83530 N/A 0%
Execution Time 1142702 N/A 0%
Rows Returned 8311456 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 sbtest6 where id between :vtg1 and :vtg2
A B Diff
Execution Count 83892 N/A 0%
Execution Time 1142564 N/A 0%
Rows Returned 8348351 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 83919 N/A 0%
Execution Time 1142293 N/A 0%
Rows Returned 8351149 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 c from sbtest5 where id between :vtg1 and :vtg2
A B Diff
Execution Count 83590 N/A 0%
Execution Time 1142102 N/A 0%
Rows Returned 8319200 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 sbtest7 where id between :vtg1 and :vtg2
A B Diff
Execution Count 83989 N/A 0%
Execution Time 1141424 N/A 0%
Rows Returned 8360299 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 sbtest10 where id between :vtg1 and :vtg2
A B Diff
Execution Count 84085 N/A 0%
Execution Time 1139950 N/A 0%
Rows Returned 8367754 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 sbtest1 where id between :vtg1 and :vtg2
A B Diff
Execution Count 84055 N/A 0%
Execution Time 1139873 N/A 0%
Rows Returned 8360516 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 sbtest9 where id between :vtg1 and :vtg2
A B Diff
Execution Count 84145 N/A 0%
Execution Time 1139154 N/A 0%
Rows Returned 8372342 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 sum(k) from sbtest4 where id between :vtg1 and :vtg2
A B Diff
Execution Count 84015 N/A 0%
Execution Time 1009919 N/A 0%
Rows Returned 84015 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 sbtest10 where id between :vtg1 and :vtg2
A B Diff
Execution Count 83759 N/A 0%
Execution Time 1009714 N/A 0%
Rows Returned 83759 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 sbtest2 where id between :vtg1 and :vtg2
A B Diff
Execution Count 84329 N/A 0%
Execution Time 1009113 N/A 0%
Rows Returned 84329 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 sum(k) from sbtest6 where id between :vtg1 and :vtg2
A B Diff
Execution Count 84255 N/A 0%
Execution Time 1008839 N/A 0%
Rows Returned 84255 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 sbtest8 where id between :vtg1 and :vtg2
A B Diff
Execution Count 83946 N/A 0%
Execution Time 1008668 N/A 0%
Rows Returned 83946 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 sbtest5 where id between :vtg1 and :vtg2
A B Diff
Execution Count 83626 N/A 0%
Execution Time 1008540 N/A 0%
Rows Returned 83626 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 sbtest3 where id between :vtg1 and :vtg2
A B Diff
Execution Count 83651 N/A 0%
Execution Time 1007491 N/A 0%
Rows Returned 83651 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 sbtest7 where id between :vtg1 and :vtg2
A B Diff
Execution Count 83927 N/A 0%
Execution Time 1007183 N/A 0%
Rows Returned 83927 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 sbtest9 where id between :vtg1 and :vtg2
A B Diff
Execution Count 83922 N/A 0%
Execution Time 1005672 N/A 0%
Rows Returned 83922 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 sbtest1 where id between :vtg1 and :vtg2
A B Diff
Execution Count 83714 N/A 0%
Execution Time 1004885 N/A 0%
Rows Returned 83714 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 c from sbtest3 where id = :id
A B Diff
Execution Count 838959 N/A 0%
Execution Time 733980 N/A 0%
Rows Returned 838959 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 sbtest8 where id = :id
A B Diff
Execution Count 839760 N/A 0%
Execution Time 733830 N/A 0%
Rows Returned 839760 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 836220 N/A 0%
Execution Time 733823 N/A 0%
Rows Returned 836220 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 sbtest9 where id = :id
A B Diff
Execution Count 836698 N/A 0%
Execution Time 733182 N/A 0%
Rows Returned 836698 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 sbtest2 where id = :id
A B Diff
Execution Count 837906 N/A 0%
Execution Time 732774 N/A 0%
Rows Returned 837906 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 sbtest4 where id = :id
A B Diff
Execution Count 837779 N/A 0%
Execution Time 732474 N/A 0%
Rows Returned 837779 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 sbtest1 where id = :id
A B Diff
Execution Count 841311 N/A 0%
Execution Time 732347 N/A 0%
Rows Returned 841311 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 sbtest10 where id = :id
A B Diff
Execution Count 842290 N/A 0%
Execution Time 731994 N/A 0%
Rows Returned 842290 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 sbtest7 where id = :id
A B Diff
Execution Count 843443 N/A 0%
Execution Time 731767 N/A 0%
Rows Returned 843443 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 c from sbtest6 where id = :id
A B Diff
Execution Count 837039 N/A 0%
Execution Time 730933 N/A 0%
Rows Returned 837039 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 distinct c from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "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 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest7 where id = :id /* INT64 */
A B Diff
Execution Count N/A 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest6 where id = :id /* INT64 */
A B Diff
Execution Count N/A 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest5 where id = :id /* INT64 */
A B Diff
Execution Count N/A 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest2 where id = :id /* INT64 */
A B Diff
Execution Count N/A 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest4 where id = :id /* INT64 */
A B Diff
Execution Count N/A 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest10 where id = :id /* INT64 */
A B Diff
Execution Count N/A 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest9 where id = :id /* INT64 */
A B Diff
Execution Count N/A 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest1 where id = :id /* INT64 */
A B Diff
Execution Count N/A 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest3 where id = :id /* INT64 */
A B Diff
Execution Count N/A 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest8 where id = :id /* INT64 */
A B Diff
Execution Count N/A 836366 0%
Execution Time N/A 736074 0%
Rows Returned N/A 836366 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id = :id /* INT64 */", "Table": "sbtest8", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }