Compare Query Plans

Comparing the query plans of two OLTP-READONLY 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 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 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 distinct c from sbtest6 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 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 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 c from sbtest7 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 sbtest4 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 sbtest5 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 sbtest2 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 sbtest1 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 sbtest1 where id between :vtg1 and :vtg2
Only A
select c from sbtest9 where id between :vtg1 and :vtg2
Only A
select c from sbtest2 where id between :vtg1 and :vtg2
Only A
select c from sbtest10 where id between :vtg1 and :vtg2
Only A
select c from sbtest5 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 sbtest7 where id between :vtg1 and :vtg2
Only A
select c from sbtest6 where id between :vtg1 and :vtg2
Only A
select c from sbtest8 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest5 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest6 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest3 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest1 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest7 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 sbtest4 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest8 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest10 where id between :vtg1 and :vtg2
Only A
select sum(k) from sbtest9 where id between :vtg1 and :vtg2
Only A
select c from sbtest2 where id = :id
Only A
select c from sbtest6 where id = :id
Only A
select c from sbtest4 where id = :id
Only A
select c from sbtest10 where id = :id
Only A
select c from sbtest1 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 sbtest3 where id = :id
Only A
select c from sbtest7 where id = :id
Only A
select c from sbtest9 where id = :id
Only A
select distinct c from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest2 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 sbtest6 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 sbtest4 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select distinct c from sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest1 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest9 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 sbtest5 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 sbtest4 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 sbtest6 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
Only B
select c from 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 sbtest2 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 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 sbtest9 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 sbtest4 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 sbtest5 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest10 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest4 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest1 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 sbtest6 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 sbtest9 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select sum(k) from sbtest2 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */
Only B
select c from sbtest2 where id = :id /* INT64 */
Only B
select c from sbtest8 where id = :id /* INT64 */
Only B
select c from sbtest3 where id = :id /* INT64 */
Only B
select c from sbtest4 where id = :id /* INT64 */
Only B
select c from sbtest1 where id = :id /* INT64 */
Only B
select c from sbtest10 where id = :id /* INT64 */
Only B
select c from sbtest6 where id = :id /* INT64 */
Only B
select c from sbtest5 where id = :id /* INT64 */
Only B
select c from sbtest9 where id = :id /* INT64 */
Only B
select c from sbtest7 where id = :id /* INT64 */
Only B
Statistics
Query select distinct c from sbtest3 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 81988 N/A 0%
Execution Time 1999168 N/A 0%
Rows Returned 8157172 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 81520 N/A 0%
Execution Time 1998998 N/A 0%
Rows Returned 8112647 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 sbtest1 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 81802 N/A 0%
Execution Time 1998345 N/A 0%
Rows Returned 8139074 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 81900 N/A 0%
Execution Time 1997504 N/A 0%
Rows Returned 8145348 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "GroupBy": "(0|1) COLLATE utf8mb4_0900_ai_ci", "Inputs": [ { "FieldQuery": "select c, weight_string(c) from sbtest5 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "OrderBy": "0 ASC COLLATE utf8mb4_0900_ai_ci, 0 ASC COLLATE utf8mb4_0900_ai_ci", "Query": "select distinct c, weight_string(c) from sbtest5 where id between :vtg1 and :vtg2 order by c asc, c asc", "Table": "sbtest5", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "ResultColumns": 1, "Variant": "Ordered" }
Statistics
Query select distinct c from sbtest6 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 81949 N/A 0%
Execution Time 1995338 N/A 0%
Rows Returned 8155833 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 sbtest9 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 82306 N/A 0%
Execution Time 1995310 N/A 0%
Rows Returned 8189914 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 sbtest8 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 81986 N/A 0%
Execution Time 1994494 N/A 0%
Rows Returned 8155573 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 82454 N/A 0%
Execution Time 1993824 N/A 0%
Rows Returned 8204248 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 sbtest4 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 82040 N/A 0%
Execution Time 1991988 N/A 0%
Rows Returned 8166106 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 82094 N/A 0%
Execution Time 1990770 N/A 0%
Rows Returned 8169620 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 sbtest7 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 82002 N/A 0%
Execution Time 1574991 N/A 0%
Rows Returned 8156060 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 sbtest6 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 82354 N/A 0%
Execution Time 1574841 N/A 0%
Rows Returned 8194360 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 sbtest4 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 82052 N/A 0%
Execution Time 1574178 N/A 0%
Rows Returned 8167204 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 sbtest9 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 82056 N/A 0%
Execution Time 1574175 N/A 0%
Rows Returned 8162564 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 sbtest5 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 81605 N/A 0%
Execution Time 1573327 N/A 0%
Rows Returned 8120792 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 sbtest3 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 81919 N/A 0%
Execution Time 1572221 N/A 0%
Rows Returned 8152889 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 sbtest2 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 82011 N/A 0%
Execution Time 1571587 N/A 0%
Rows Returned 8161019 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 sbtest10 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 81972 N/A 0%
Execution Time 1568918 N/A 0%
Rows Returned 8157471 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 sbtest1 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 82287 N/A 0%
Execution Time 1568088 N/A 0%
Rows Returned 8186048 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 sbtest8 where id between :vtg1 and :vtg2 order by c asc
A B Diff
Execution Count 81780 N/A 0%
Execution Time 1567027 N/A 0%
Rows Returned 8137723 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 sbtest1 where id between :vtg1 and :vtg2
A B Diff
Execution Count 82105 N/A 0%
Execution Time 1252323 N/A 0%
Rows Returned 8171131 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 81535 N/A 0%
Execution Time 1252139 N/A 0%
Rows Returned 8111756 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 sbtest2 where id between :vtg1 and :vtg2
A B Diff
Execution Count 81504 N/A 0%
Execution Time 1251270 N/A 0%
Rows Returned 8112104 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 sbtest10 where id between :vtg1 and :vtg2
A B Diff
Execution Count 81490 N/A 0%
Execution Time 1250769 N/A 0%
Rows Returned 8107343 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 sbtest5 where id between :vtg1 and :vtg2
A B Diff
Execution Count 81801 N/A 0%
Execution Time 1250391 N/A 0%
Rows Returned 8138838 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 sbtest4 where id between :vtg1 and :vtg2
A B Diff
Execution Count 82550 N/A 0%
Execution Time 1249794 N/A 0%
Rows Returned 8214814 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 82100 N/A 0%
Execution Time 1248679 N/A 0%
Rows Returned 8171690 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 between :vtg1 and :vtg2
A B Diff
Execution Count 82482 N/A 0%
Execution Time 1248622 N/A 0%
Rows Returned 8210916 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id between :vtg1 and :vtg2", "Table": "sbtest7", "Variant": "Scatter" }
Statistics
Query select c from sbtest6 where id between :vtg1 and :vtg2
A B Diff
Execution Count 82302 N/A 0%
Execution Time 1248598 N/A 0%
Rows Returned 8190278 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 82163 N/A 0%
Execution Time 1245433 N/A 0%
Rows Returned 8177052 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest8 where id between :vtg1 and :vtg2", "Table": "sbtest8", "Variant": "Scatter" }
Statistics
Query select sum(k) from sbtest5 where id between :vtg1 and :vtg2
A B Diff
Execution Count 81442 N/A 0%
Execution Time 1112268 N/A 0%
Rows Returned 81442 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 sbtest6 where id between :vtg1 and :vtg2
A B Diff
Execution Count 82145 N/A 0%
Execution Time 1109398 N/A 0%
Rows Returned 82145 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest6 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest6 where id between :vtg1 and :vtg2", "Table": "sbtest6", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest3 where id between :vtg1 and :vtg2
A B Diff
Execution Count 82080 N/A 0%
Execution Time 1109184 N/A 0%
Rows Returned 82080 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest3 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest3 where id between :vtg1 and :vtg2", "Table": "sbtest3", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest1 where id between :vtg1 and :vtg2
A B Diff
Execution Count 81400 N/A 0%
Execution Time 1108523 N/A 0%
Rows Returned 81400 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest1 where id between :vtg1 and :vtg2", "Table": "sbtest1", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest7 where id between :vtg1 and :vtg2
A B Diff
Execution Count 81809 N/A 0%
Execution Time 1107981 N/A 0%
Rows Returned 81809 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 sbtest2 where id between :vtg1 and :vtg2
A B Diff
Execution Count 82224 N/A 0%
Execution Time 1107952 N/A 0%
Rows Returned 82224 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 sbtest4 where id between :vtg1 and :vtg2
A B Diff
Execution Count 82231 N/A 0%
Execution Time 1106723 N/A 0%
Rows Returned 82231 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 sbtest8 where id between :vtg1 and :vtg2
A B Diff
Execution Count 82455 N/A 0%
Execution Time 1106521 N/A 0%
Rows Returned 82455 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "Aggregates": "sum(0) AS sum(k)", "Inputs": [ { "FieldQuery": "select sum(k) from sbtest8 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(k) from sbtest8 where id between :vtg1 and :vtg2", "Table": "sbtest8", "Variant": "Scatter" } ], "OperatorType": "Aggregate", "Variant": "Scalar" }
Statistics
Query select sum(k) from sbtest10 where id between :vtg1 and :vtg2
A B Diff
Execution Count 82078 N/A 0%
Execution Time 1106090 N/A 0%
Rows Returned 82078 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 sbtest9 where id between :vtg1 and :vtg2
A B Diff
Execution Count 82171 N/A 0%
Execution Time 1104346 N/A 0%
Rows Returned 82171 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 sbtest2 where id = :id
A B Diff
Execution Count 821370 N/A 0%
Execution Time 778193 N/A 0%
Rows Returned 821370 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 sbtest6 where id = :id
A B Diff
Execution Count 818409 N/A 0%
Execution Time 776672 N/A 0%
Rows Returned 818409 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c from sbtest6 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest6 where id = :id", "Table": "sbtest6", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest4 where id = :id
A B Diff
Execution Count 820633 N/A 0%
Execution Time 776524 N/A 0%
Rows Returned 820633 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 sbtest10 where id = :id
A B Diff
Execution Count 823730 N/A 0%
Execution Time 776366 N/A 0%
Rows Returned 823730 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 sbtest1 where id = :id
A B Diff
Execution Count 821600 N/A 0%
Execution Time 776245 N/A 0%
Rows Returned 821600 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 sbtest8 where id = :id
A B Diff
Execution Count 821163 N/A 0%
Execution Time 775882 N/A 0%
Rows Returned 821163 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 815590 N/A 0%
Execution Time 775841 N/A 0%
Rows Returned 815590 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 sbtest3 where id = :id
A B Diff
Execution Count 822143 N/A 0%
Execution Time 775711 N/A 0%
Rows Returned 822143 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 sbtest7 where id = :id
A B Diff
Execution Count 818637 N/A 0%
Execution Time 775537 N/A 0%
Rows Returned 818637 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 sbtest9 where id = :id
A B Diff
Execution Count 816939 N/A 0%
Execution Time 774477 N/A 0%
Rows Returned 816939 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 sbtest8 where id between :vtg1 /* INT64 */ and :vtg2 /* INT64 */ order by c asc
A B Diff
Execution Count N/A 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "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 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest2 where id = :id /* INT64 */
A B Diff
Execution Count N/A 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest8 where id = :id /* INT64 */
A B Diff
Execution Count N/A 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest3 where id = :id /* INT64 */
A B Diff
Execution Count N/A 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest4 where id = :id /* INT64 */
A B Diff
Execution Count N/A 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest1 where id = :id /* INT64 */
A B Diff
Execution Count N/A 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest10 where id = :id /* INT64 */
A B Diff
Execution Count N/A 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest6 where id = :id /* INT64 */
A B Diff
Execution Count N/A 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest5 where id = :id /* INT64 */
A B Diff
Execution Count N/A 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest9 where id = :id /* INT64 */
A B Diff
Execution Count N/A 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c from sbtest7 where id = :id /* INT64 */
A B Diff
Execution Count N/A 829656 0%
Execution Time N/A 772226 0%
Rows Returned N/A 829656 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select c from sbtest7 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c from sbtest7 where id = :id /* INT64 */", "Table": "sbtest7", "Values": [ ":id" ], "Variant": "EqualUnique", "Vindex": "hash" }