Compare Query Plans

Comparing the query plans of two OLTP-READONLY-OLAP 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 c from sbtest10 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest3 where id = :id
Only A
select distinct c from sbtest9 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest8 where id between :vtg1 and :vtg2
Only A
select c from sbtest3 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
Only A
select c from sbtest1 where id between :vtg1 and :vtg2
Only A
select distinct c from sbtest3 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 c from sbtest2 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 sbtest9 where id between :vtg1 and :vtg2
Only A
select c from sbtest3 where id between :vtg1 and :vtg2
Only A
select c from sbtest7 where id = :id
Only A
select c from sbtest2 where id = :id
Only A
select c from sbtest2 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest6 where id between :vtg1 and :vtg2
Only A
select distinct c from sbtest8 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 sbtest8 where id = :id
Only A
select sum(k) 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 sbtest6 where id = :id
Only A
select distinct c from sbtest6 where id between :vtg1 and :vtg2 order by c asc
Only A
select sum(k) from sbtest3 where id between :vtg1 and :vtg2
Only A
select c from sbtest1 where id = :id
Only A
select c from sbtest4 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 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 sbtest10 where id = :id
Only A
select sum(k) from sbtest4 where id between :vtg1 and :vtg2
Only A
select c from sbtest10 where id between :vtg1 and :vtg2
Only A
select c from sbtest6 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 c from sbtest4 where id between :vtg1 and :vtg2
Only A
select distinct c from sbtest10 where id between :vtg1 and :vtg2 order by c asc
Only A
select c from sbtest5 where id = :id
Only A
select c from sbtest9 where id = :id
Only A
select distinct c from sbtest4 where id between :vtg1 and :vtg2 order by c asc
Only A
select sum(k) from sbtest5 where id between :vtg1 and :vtg2
Only A
select distinct c from sbtest1 where id between :vtg1 and :vtg2 order by c asc
Only A
select sum(k) from sbtest10 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest1 where id between :vtg1 and :vtg2
Only A
select c from sbtest6 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest9 where id between :vtg1 and :vtg2
Only A
select c from sbtest4 where id = :id
Only A
select sum(k) from sbtest8 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest7 where id between :vtg1 and :vtg2
Only A
select c from sbtest2 where id = :id /* INT64 */
Only B
select c from sbtest4 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 */
Only B
select c from sbtest1 where id = :id /* INT64 */
Only B
select distinct c from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select sum(k) from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest10 where id = :id /* INT64 */
Only B
select sum(k) from sbtest4 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 sum(k) from sbtest7 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
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 sbtest3 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 c from sbtest5 where id = :id /* INT64 */
Only B
select c from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest7 where id = :id /* INT64 */
Only B
select c from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest8 where id = :id /* INT64 */
Only B
select c from sbtest6 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select distinct c from sbtest2 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 */
Only B
select c from sbtest6 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 sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest3 where id = :id /* INT64 */
Only B
select sum(k) from sbtest3 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest8 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 */
Only B
select distinct c from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select sum(k) from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest4 where id = :id /* INT64 */
Only B
select c from sbtest3 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest9 where id = :id /* INT64 */
Only B
select sum(k) from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest10 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 sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest5 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 sum(k) from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select distinct c from sbtest8 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 sum(k) from sbtest6 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 c from sbtest6 where id = :id /* INT64 */
Only B
select distinct c from sbtest7 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 sum(k) from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
Statistics
Query select c from sbtest10 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest3 where id = :id
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 distinct c from sbtest9 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 c from sbtest8 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest3 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest9 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest1 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 distinct c from sbtest3 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest7 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 c from sbtest2 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest5 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest9 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest3 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest7 where id = :id
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest2 where id = :id
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest2 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sum(k) from sbtest6 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 distinct c from sbtest8 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest8 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest8 where id = :id
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sum(k) from sbtest2 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest5 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest6 where id = :id
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest6 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sum(k) from sbtest3 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 c from sbtest1 where id = :id
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest4 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest1 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 distinct c from sbtest5 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest10 where id = :id
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sum(k) from sbtest4 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 c from sbtest10 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest6 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 distinct c from sbtest2 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 c from sbtest4 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 distinct c from sbtest10 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 c from sbtest5 where id = :id
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 distinct c from sbtest4 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sum(k) from sbtest5 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 distinct c from sbtest1 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sum(k) from sbtest10 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest1 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest6 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sum(k) from sbtest9 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 c from sbtest4 where id = :id
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sum(k) from sbtest8 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 sbtest7 where id between :vtg1 and :vtg2
A B Diff
Execution Count 0 N/A 0%
Execution Time 0 N/A 0%
Rows Returned 0 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 c from sbtest2 where id = :id /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest4 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest1 where id = :id /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select sum(k) from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest10 where id = :id /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select sum(k) from sbtest4 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select sum(k) from sbtest7 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest5 where id = :id /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest7 where id = :id /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest8 where id = :id /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest6 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest3 where id = :id /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select sum(k) from sbtest3 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest7 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select sum(k) from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest4 where id = :id /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest3 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest9 where id = :id /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select sum(k) from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select sum(k) from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select sum(k) from sbtest6 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select sum(k) from sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select c from sbtest6 where id = :id /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
Statistics
Query select sum(k) from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
A B Diff
Execution Count N/A 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }
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 0 0%
Execution Time N/A 0 0%
Rows Returned N/A 0 0%
Errors N/A 0 0%
Query Plan B
{ "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 /* INT64 */ and :vtg2 /* INT64 */ order by c asc", "Table": "sbtest9", "Variant": "Scatter" }