Compare Query Plans

Comparing the query plans of two TPCC 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 no_o_id from new_orders1 where no_d_id = :no_d_id and no_w_id = :no_d_id order by no_o_id asc limit :vtg1 for update
Only A
select d_next_o_id, d_tax from district1 where d_w_id = :d_w_id and d_id = :d_w_id for update
Only A
select d_next_o_id, d_tax from district1 where d_w_id = :d_w_id and d_id = :d_id for update
Only A
select count(distinct s.s_i_id) from stock1 as s join order_line1 as ol on ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id where ol.ol_w_id = :ol_ol_w_id and ol.ol_d_id = :ol_ol_w_id and ol.ol_o_id < :ol_ol_o_id and ol.ol_o_id >= :ol_ol_o_id1 and s.s_w_id = :ol_ol_w_id and s.s_quantity < :s_s_quantity
Only A
select count(distinct s.s_i_id) from stock1 as s join order_line1 as ol on ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id where ol.ol_w_id = :ol_ol_w_id and ol.ol_d_id = :ol_ol_d_id and ol.ol_o_id < :ol_ol_o_id and ol.ol_o_id >= :ol_ol_o_id1 and s.s_w_id = :ol_ol_w_id and s.s_quantity < :s_s_quantity
Only A
select count(distinct s.s_i_id) from stock1 as s join order_line1 as ol on ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id where ol.ol_w_id = :ol_ol_w_id and ol.ol_d_id = :ol_ol_d_id and ol.ol_o_id < :ol_ol_o_id and ol.ol_o_id >= :ol_ol_o_id1 and s.s_w_id = :ol_ol_w_id and s.s_quantity < :ol_ol_d_id
Only A
select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_w_id for update
Only A
select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id and o_d_id = :o_d_id and o_c_id = :o_w_id order by o_id desc
Only A
select s_quantity, s_data, s_dist_03 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_i_id for update
Only A
select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id and o_d_id = :o_w_id and o_c_id = :o_w_id order by o_id desc
Only A
select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_w_id
Only A
select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id and c_d_id = :c_d_id and c_id = :w_id
Only A
select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id and c_d_id = :c_d_id and c_id = :c_d_id
Only A
select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_w_id for update
Only A
select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id and c_d_id = :w_id and c_id = :c_id
Only A
select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id and c_d_id = :c_d_id and c_id = :c_id
Only A
select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_d_id for update
Only A
select no_o_id from new_orders1 where no_d_id = :no_d_id and no_w_id = :no_w_id order by no_o_id asc limit :vtg1 for update
Only A
select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_id
Only A
select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_id
Only A
select d_next_o_id from district1 where d_id = :d_id and d_w_id = :d_w_id
Only A
select d_next_o_id from district1 where d_id = :d_id and d_w_id = :d_id
Only A
select c_balance, c_first, c_middle, c_id from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_last = :c_last order by c_first asc
Only A
select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_id for update
Only A
select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_id for update
Only A
select c_balance, c_first, c_middle, c_id from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_last = :c_last order by c_first asc
Only A
select count(c_id) as namecnt from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_last = :c_last
Only A
select count(c_id) as namecnt from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_last = :c_last
Only A
select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id and o_d_id = :o_d_id and o_c_id = :o_c_id order by o_id desc
Only A
select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id and o_d_id = :o_w_id and o_c_id = :o_c_id order by o_id desc
Only A
select ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d from order_line1 where ol_w_id = :ol_w_id and ol_d_id = :ol_d_id and ol_o_id = :ol_d_id
Only A
select ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d from order_line1 where ol_w_id = :ol_w_id and ol_d_id = :ol_w_id and ol_o_id = :ol_w_id
Only A
select c_id from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_last = :c_last order by c_first asc
Only A
select c_id from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_last = :c_last order by c_first asc
Only A
select sum(ol_amount) as sm from order_line1 where ol_o_id = :ol_o_id and ol_d_id = :ol_d_id and ol_w_id = :ol_d_id
Only A
select w_street_1, w_street_2, w_city, w_state, w_zip, w_name from warehouse1 where w_id = :w_id
Only A
select d_street_1, d_street_2, d_city, d_state, d_zip, d_name from district1 where d_w_id = :d_w_id and d_id = :d_w_id
Only A
select d_street_1, d_street_2, d_city, d_state, d_zip, d_name from district1 where d_w_id = :d_w_id and d_id = :d_id
Only A
select sum(ol_amount) as sm from order_line1 where ol_o_id = :ol_o_id and ol_d_id = :ol_d_id and ol_w_id = :ol_w_id
Only A
select o_c_id from orders1 where o_id = :o_id and o_d_id = :o_d_id and o_w_id = :o_d_id
Only A
select i_price, i_name, i_data from item1 where i_id = :i_id
Only A
select s_quantity, s_data, s_dist_01 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
Only A
select s_quantity, s_data, s_dist_03 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
Only A
select s_quantity, s_data, s_dist_02 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
Only A
select s_quantity, s_data, s_dist_04 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
Only A
select s_quantity, s_data, s_dist_05 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
Only A
select s_quantity, s_data, s_dist_08 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
Only A
select s_quantity, s_data, s_dist_07 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
Only A
select s_quantity, s_data, s_dist_06 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
Only A
select s_quantity, s_data, s_dist_10 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
Only A
select c_data from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_id
Only A
select s_quantity, s_data, s_dist_09 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
Only A
select c_data from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_id
Only A
select i_price, i_name, i_data from item1 where i_id = -:vtg1
Only A
select o_c_id from orders1 where o_id = :o_id and o_d_id = :o_d_id and o_w_id = :o_w_id
Only A
select no_o_id from new_orders1 where no_d_id = :no_d_id /* INT64 */ and no_w_id = :no_d_id /* INT64 */ order by no_o_id asc limit :vtg1 /* INT64 */ for update
Only B
select d_next_o_id, d_tax from district1 where d_w_id = :d_w_id /* INT64 */ and d_id = :d_w_id /* INT64 */ for update
Only B
select d_next_o_id, d_tax from district1 where d_w_id = :d_w_id /* INT64 */ and d_id = :d_id /* INT64 */ for update
Only B
select count(distinct s.s_i_id) from stock1 as s join order_line1 as ol on ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id where ol.ol_w_id = :ol_ol_w_id /* INT64 */ and ol.ol_d_id = :ol_ol_d_id /* INT64 */ and ol.ol_o_id < :ol_ol_o_id /* INT64 */ and ol.ol_o_id >= :ol_ol_o_id1 /* INT64 */ and s.s_w_id = :ol_ol_w_id /* INT64 */ and s.s_quantity < :ol_ol_d_id /* INT64 */
Only B
select count(distinct s.s_i_id) from stock1 as s join order_line1 as ol on ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id where ol.ol_w_id = :ol_ol_w_id /* INT64 */ and ol.ol_d_id = :ol_ol_w_id /* INT64 */ and ol.ol_o_id < :ol_ol_o_id /* INT64 */ and ol.ol_o_id >= :ol_ol_o_id1 /* INT64 */ and s.s_w_id = :ol_ol_w_id /* INT64 */ and s.s_quantity < :s_s_quantity /* INT64 */
Only B
select count(distinct s.s_i_id) from stock1 as s join order_line1 as ol on ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id where ol.ol_w_id = :ol_ol_w_id /* INT64 */ and ol.ol_d_id = :ol_ol_d_id /* INT64 */ and ol.ol_o_id < :ol_ol_o_id /* INT64 */ and ol.ol_o_id >= :ol_ol_o_id1 /* INT64 */ and s.s_w_id = :ol_ol_w_id /* INT64 */ and s.s_quantity < :s_s_quantity /* INT64 */
Only B
select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_d_id /* INT64 */
Only B
select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_c_id = :o_w_id /* INT64 */ order by o_id desc
Only B
select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :w_id /* INT64 */
Only B
select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_id = :c_w_id /* INT64 */ for update
Only B
select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_c_id = :o_d_id /* INT64 */ order by o_id desc
Only B
select s_quantity, s_data, s_dist_08 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_i_id /* INT64 */ for update
Only B
select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_d_id /* INT64 */
Only B
select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_d_id /* INT64 */ for update
Only B
select no_o_id from new_orders1 where no_d_id = :no_d_id /* INT64 */ and no_w_id = :no_w_id /* INT64 */ order by no_o_id asc limit :vtg1 /* INT64 */ for update
Only B
select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_id /* INT64 */
Only B
select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id /* INT64 */ and c_d_id = :w_id /* INT64 */ and c_id = :c_id /* INT64 */
Only B
select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_id /* INT64 */
Only B
select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_w_id /* INT64 */ for update
Only B
select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_id = :c_id /* INT64 */
Only B
select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_id = :c_id /* INT64 */ for update
Only B
select d_next_o_id from district1 where d_id = :d_id /* INT64 */ and d_w_id = :d_id /* INT64 */
Only B
select d_next_o_id from district1 where d_id = :d_id /* INT64 */ and d_w_id = :d_w_id /* INT64 */
Only B
select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_id /* INT64 */ for update
Only B
select c_balance, c_first, c_middle, c_id from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_last = :c_last /* VARCHAR */ order by c_first asc
Only B
select c_balance, c_first, c_middle, c_id from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_last = :c_last /* VARCHAR */ order by c_first asc
Only B
select count(c_id) as namecnt from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_last = :c_last /* VARCHAR */
Only B
select count(c_id) as namecnt from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_last = :c_last /* VARCHAR */
Only B
select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_c_id = :o_c_id /* INT64 */ order by o_id desc
Only B
select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id /* INT64 */ and o_d_id = :o_w_id /* INT64 */ and o_c_id = :o_c_id /* INT64 */ order by o_id desc
Only B
select ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d from order_line1 where ol_w_id = :ol_w_id /* INT64 */ and ol_d_id = :ol_d_id /* INT64 */ and ol_o_id = :ol_d_id /* INT64 */
Only B
select ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d from order_line1 where ol_w_id = :ol_w_id /* INT64 */ and ol_d_id = :ol_w_id /* INT64 */ and ol_o_id = :ol_w_id /* INT64 */
Only B
select c_id from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_last = :c_last /* VARCHAR */ order by c_first asc
Only B
select c_id from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_last = :c_last /* VARCHAR */ order by c_first asc
Only B
select sum(ol_amount) as sm from order_line1 where ol_o_id = :ol_o_id /* INT64 */ and ol_d_id = :ol_d_id /* INT64 */ and ol_w_id = :ol_d_id /* INT64 */
Only B
select w_street_1, w_street_2, w_city, w_state, w_zip, w_name from warehouse1 where w_id = :w_id /* INT64 */
Only B
select d_street_1, d_street_2, d_city, d_state, d_zip, d_name from district1 where d_w_id = :d_w_id /* INT64 */ and d_id = :d_w_id /* INT64 */
Only B
select d_street_1, d_street_2, d_city, d_state, d_zip, d_name from district1 where d_w_id = :d_w_id /* INT64 */ and d_id = :d_id /* INT64 */
Only B
select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_d_id /* INT64 */
Only B
select i_price, i_name, i_data from item1 where i_id = :i_id /* INT64 */
Only B
select sum(ol_amount) as sm from order_line1 where ol_o_id = :ol_o_id /* INT64 */ and ol_d_id = :ol_d_id /* INT64 */ and ol_w_id = :ol_w_id /* INT64 */
Only B
select s_quantity, s_data, s_dist_03 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
Only B
select s_quantity, s_data, s_dist_04 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
Only B
select s_quantity, s_data, s_dist_02 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
Only B
select c_data from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_id = :c_id /* INT64 */
Only B
select s_quantity, s_data, s_dist_01 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
Only B
select s_quantity, s_data, s_dist_05 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
Only B
select s_quantity, s_data, s_dist_06 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
Only B
select s_quantity, s_data, s_dist_09 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
Only B
select s_quantity, s_data, s_dist_10 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
Only B
select c_data from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_id /* INT64 */
Only B
select s_quantity, s_data, s_dist_07 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
Only B
select s_quantity, s_data, s_dist_08 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
Only B
select i_price, i_name, i_data from item1 where i_id = -:vtg1 /* INT64 */
Only B
select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */
Only B
Statistics
Query select no_o_id from new_orders1 where no_d_id = :no_d_id and no_w_id = :no_d_id order by no_o_id asc limit :vtg1 for update
A B Diff
Execution Count 3243 N/A 0%
Execution Time 31830581 N/A 0%
Rows Returned 3160 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select no_o_id from new_orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select no_o_id from new_orders1 where no_d_id = :no_d_id and no_w_id = :no_d_id order by no_o_id asc limit :vtg1 for update", "Table": "new_orders1", "Values": [ ":no_d_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select d_next_o_id, d_tax from district1 where d_w_id = :d_w_id and d_id = :d_w_id for update
A B Diff
Execution Count 3219 N/A 0%
Execution Time 17297624 N/A 0%
Rows Returned 3219 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select d_next_o_id, d_tax from district1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select d_next_o_id, d_tax from district1 where d_w_id = :d_w_id and d_id = :d_w_id for update", "Table": "district1", "Values": [ ":d_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select d_next_o_id, d_tax from district1 where d_w_id = :d_w_id and d_id = :d_id for update
A B Diff
Execution Count 28353 N/A 0%
Execution Time 12444545 N/A 0%
Rows Returned 28353 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select d_next_o_id, d_tax from district1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select d_next_o_id, d_tax from district1 where d_w_id = :d_w_id and d_id = :d_id for update", "Table": "district1", "Values": [ ":d_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select count(distinct s.s_i_id) from stock1 as s join order_line1 as ol on ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id where ol.ol_w_id = :ol_ol_w_id and ol.ol_d_id = :ol_ol_w_id and ol.ol_o_id < :ol_ol_o_id and ol.ol_o_id >= :ol_ol_o_id1 and s.s_w_id = :ol_ol_w_id and s.s_quantity < :s_s_quantity
A B Diff
Execution Count 332 N/A 0%
Execution Time 3199109 N/A 0%
Rows Returned 332 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select count(distinct s.s_i_id) from stock1 as s, order_line1 as ol where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select count(distinct s.s_i_id) from stock1 as s, order_line1 as ol where s.s_w_id = :ol_ol_w_id and s.s_quantity \u003c :s_s_quantity and ol.ol_w_id = :ol_ol_w_id and ol.ol_d_id = :ol_ol_w_id and ol.ol_o_id \u003c :ol_ol_o_id and ol.ol_o_id \u003e= :ol_ol_o_id1 and ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id", "Table": "order_line1, stock1", "Values": [ ":ol_ol_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select count(distinct s.s_i_id) from stock1 as s join order_line1 as ol on ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id where ol.ol_w_id = :ol_ol_w_id and ol.ol_d_id = :ol_ol_d_id and ol.ol_o_id < :ol_ol_o_id and ol.ol_o_id >= :ol_ol_o_id1 and s.s_w_id = :ol_ol_w_id and s.s_quantity < :s_s_quantity
A B Diff
Execution Count 2830 N/A 0%
Execution Time 3192612 N/A 0%
Rows Returned 2830 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select count(distinct s.s_i_id) from stock1 as s, order_line1 as ol where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select count(distinct s.s_i_id) from stock1 as s, order_line1 as ol where s.s_w_id = :ol_ol_w_id and s.s_quantity \u003c :s_s_quantity and ol.ol_w_id = :ol_ol_w_id and ol.ol_d_id = :ol_ol_d_id and ol.ol_o_id \u003c :ol_ol_o_id and ol.ol_o_id \u003e= :ol_ol_o_id1 and ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id", "Table": "order_line1, stock1", "Values": [ ":ol_ol_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select count(distinct s.s_i_id) from stock1 as s join order_line1 as ol on ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id where ol.ol_w_id = :ol_ol_w_id and ol.ol_d_id = :ol_ol_d_id and ol.ol_o_id < :ol_ol_o_id and ol.ol_o_id >= :ol_ol_o_id1 and s.s_w_id = :ol_ol_w_id and s.s_quantity < :ol_ol_d_id
A B Diff
Execution Count 31 N/A 0%
Execution Time 3159391 N/A 0%
Rows Returned 31 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select count(distinct s.s_i_id) from stock1 as s, order_line1 as ol where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select count(distinct s.s_i_id) from stock1 as s, order_line1 as ol where s.s_w_id = :ol_ol_w_id and s.s_quantity \u003c :ol_ol_d_id and ol.ol_w_id = :ol_ol_w_id and ol.ol_d_id = :ol_ol_d_id and ol.ol_o_id \u003c :ol_ol_o_id and ol.ol_o_id \u003e= :ol_ol_o_id1 and ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id", "Table": "order_line1, stock1", "Values": [ ":ol_ol_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_w_id for update
A B Diff
Execution Count 2 N/A 0%
Execution Time 2508355 N/A 0%
Rows Returned 2 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_w_id for update", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id and o_d_id = :o_d_id and o_c_id = :o_w_id order by o_id desc
A B Diff
Execution Count 2 N/A 0%
Execution Time 2219683 N/A 0%
Rows Returned 3 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select o_id, o_carrier_id, o_entry_d from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id and o_d_id = :o_d_id and o_c_id = :o_w_id order by o_id desc", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_03 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_i_id for update
A B Diff
Execution Count 1 N/A 0%
Execution Time 2094929 N/A 0%
Rows Returned 1 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select s_quantity, s_data, s_dist_03 as s_dist from stock1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select s_quantity, s_data, s_dist_03 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_i_id for update", "Table": "stock1", "Values": [ ":s_i_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id and o_d_id = :o_w_id and o_c_id = :o_w_id order by o_id desc
A B Diff
Execution Count 1 N/A 0%
Execution Time 1905078 N/A 0%
Rows Returned 1 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select o_id, o_carrier_id, o_entry_d from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id and o_d_id = :o_w_id and o_c_id = :o_w_id order by o_id desc", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_w_id
A B Diff
Execution Count 1 N/A 0%
Execution Time 1904537 N/A 0%
Rows Returned 1 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_balance, c_first, c_middle, c_last from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_w_id", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id and c_d_id = :c_d_id and c_id = :w_id
A B Diff
Execution Count 9 N/A 0%
Execution Time 1836477 N/A 0%
Rows Returned 9 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_discount, c_last, c_credit, w_tax from customer1 as c, warehouse1 as w where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_discount, c_last, c_credit, w_tax from customer1 as c, warehouse1 as w where c_d_id = :c_d_id and c_id = :w_id and w_id = :w_id and c_w_id = w_id", "Table": "customer1, warehouse1", "Values": [ ":w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id and c_d_id = :c_d_id and c_id = :c_d_id
A B Diff
Execution Count 7 N/A 0%
Execution Time 1744089 N/A 0%
Rows Returned 7 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_discount, c_last, c_credit, w_tax from customer1 as c, warehouse1 as w where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_discount, c_last, c_credit, w_tax from customer1 as c, warehouse1 as w where c_d_id = :c_d_id and c_id = :c_d_id and w_id = :w_id and c_w_id = w_id", "Table": "customer1, warehouse1", "Values": [ ":w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_w_id for update
A B Diff
Execution Count 11 N/A 0%
Execution Time 1698859 N/A 0%
Rows Returned 11 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_w_id for update", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id and c_d_id = :w_id and c_id = :c_id
A B Diff
Execution Count 3219 N/A 0%
Execution Time 1492777 N/A 0%
Rows Returned 3219 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_discount, c_last, c_credit, w_tax from customer1 as c, warehouse1 as w where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_discount, c_last, c_credit, w_tax from customer1 as c, warehouse1 as w where c_d_id = :w_id and c_id = :c_id and w_id = :w_id and c_w_id = w_id", "Table": "customer1, warehouse1", "Values": [ ":w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id and c_d_id = :c_d_id and c_id = :c_id
A B Diff
Execution Count 28328 N/A 0%
Execution Time 1443271 N/A 0%
Rows Returned 28328 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_discount, c_last, c_credit, w_tax from customer1 as c, warehouse1 as w where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_discount, c_last, c_credit, w_tax from customer1 as c, warehouse1 as w where c_d_id = :c_d_id and c_id = :c_id and w_id = :w_id and c_w_id = w_id", "Table": "customer1, warehouse1", "Values": [ ":w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_d_id for update
A B Diff
Execution Count 14 N/A 0%
Execution Time 1435420 N/A 0%
Rows Returned 14 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_d_id for update", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select no_o_id from new_orders1 where no_d_id = :no_d_id and no_w_id = :no_w_id order by no_o_id asc limit :vtg1 for update
A B Diff
Execution Count 29187 N/A 0%
Execution Time 1382636 N/A 0%
Rows Returned 27738 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select no_o_id from new_orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select no_o_id from new_orders1 where no_d_id = :no_d_id and no_w_id = :no_w_id order by no_o_id asc limit :vtg1 for update", "Table": "new_orders1", "Values": [ ":no_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_id
A B Diff
Execution Count 117 N/A 0%
Execution Time 1326194 N/A 0%
Rows Returned 117 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_balance, c_first, c_middle, c_last from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_id", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_id
A B Diff
Execution Count 1139 N/A 0%
Execution Time 1323446 N/A 0%
Rows Returned 1139 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_balance, c_first, c_middle, c_last from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_id", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select d_next_o_id from district1 where d_id = :d_id and d_w_id = :d_w_id
A B Diff
Execution Count 2861 N/A 0%
Execution Time 1219420 N/A 0%
Rows Returned 2861 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select d_next_o_id from district1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select d_next_o_id from district1 where d_id = :d_id and d_w_id = :d_w_id", "Table": "district1", "Values": [ ":d_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select d_next_o_id from district1 where d_id = :d_id and d_w_id = :d_id
A B Diff
Execution Count 332 N/A 0%
Execution Time 1204620 N/A 0%
Rows Returned 332 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select d_next_o_id from district1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select d_next_o_id from district1 where d_id = :d_id and d_w_id = :d_id", "Table": "district1", "Values": [ ":d_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_balance, c_first, c_middle, c_id from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_last = :c_last order by c_first asc
A B Diff
Execution Count 1710 N/A 0%
Execution Time 1199608 N/A 0%
Rows Returned 5206 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_balance, c_first, c_middle, c_id from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_balance, c_first, c_middle, c_id from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_last = :c_last order by c_first asc", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_id for update
A B Diff
Execution Count 3174 N/A 0%
Execution Time 1195902 N/A 0%
Rows Returned 3174 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_id for update", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_id for update
A B Diff
Execution Count 28310 N/A 0%
Execution Time 1191755 N/A 0%
Rows Returned 28310 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_id for update", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_balance, c_first, c_middle, c_id from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_last = :c_last order by c_first asc
A B Diff
Execution Count 189 N/A 0%
Execution Time 1169850 N/A 0%
Rows Returned 583 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_balance, c_first, c_middle, c_id from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_balance, c_first, c_middle, c_id from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_last = :c_last order by c_first asc", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select count(c_id) as namecnt from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_last = :c_last
A B Diff
Execution Count 18773 N/A 0%
Execution Time 1166800 N/A 0%
Rows Returned 18773 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select count(c_id) as namecnt from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select count(c_id) as namecnt from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_last = :c_last", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select count(c_id) as namecnt from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_last = :c_last
A B Diff
Execution Count 2087 N/A 0%
Execution Time 1155462 N/A 0%
Rows Returned 2087 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select count(c_id) as namecnt from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select count(c_id) as namecnt from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_last = :c_last", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id and o_d_id = :o_d_id and o_c_id = :o_c_id order by o_id desc
A B Diff
Execution Count 2847 N/A 0%
Execution Time 1144605 N/A 0%
Rows Returned 4299 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select o_id, o_carrier_id, o_entry_d from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id and o_d_id = :o_d_id and o_c_id = :o_c_id order by o_id desc", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id and o_d_id = :o_w_id and o_c_id = :o_c_id order by o_id desc
A B Diff
Execution Count 306 N/A 0%
Execution Time 1142085 N/A 0%
Rows Returned 482 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select o_id, o_carrier_id, o_entry_d from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id and o_d_id = :o_w_id and o_c_id = :o_c_id order by o_id desc", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d from order_line1 where ol_w_id = :ol_w_id and ol_d_id = :ol_d_id and ol_o_id = :ol_d_id
A B Diff
Execution Count 2849 N/A 0%
Execution Time 1115642 N/A 0%
Rows Returned 33137 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d from order_line1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d from order_line1 where ol_w_id = :ol_w_id and ol_d_id = :ol_d_id and ol_o_id = :ol_d_id", "Table": "order_line1", "Values": [ ":ol_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d from order_line1 where ol_w_id = :ol_w_id and ol_d_id = :ol_w_id and ol_o_id = :ol_w_id
A B Diff
Execution Count 307 N/A 0%
Execution Time 1107350 N/A 0%
Rows Returned 2763 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d from order_line1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d from order_line1 where ol_w_id = :ol_w_id and ol_d_id = :ol_w_id and ol_o_id = :ol_w_id", "Table": "order_line1", "Values": [ ":ol_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_id from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_last = :c_last order by c_first asc
A B Diff
Execution Count 1898 N/A 0%
Execution Time 1059063 N/A 0%
Rows Returned 5652 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_id from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_id from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_last = :c_last order by c_first asc", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_id from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_last = :c_last order by c_first asc
A B Diff
Execution Count 17063 N/A 0%
Execution Time 1056707 N/A 0%
Rows Returned 50941 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_id from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_id from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_last = :c_last order by c_first asc", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(ol_amount) as sm from order_line1 where ol_o_id = :ol_o_id and ol_d_id = :ol_d_id and ol_w_id = :ol_d_id
A B Diff
Execution Count 3160 N/A 0%
Execution Time 1034837 N/A 0%
Rows Returned 3160 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select sum(ol_amount) as sm from order_line1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(ol_amount) as sm from order_line1 where ol_o_id = :ol_o_id and ol_d_id = :ol_d_id and ol_w_id = :ol_d_id", "Table": "order_line1", "Values": [ ":ol_d_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select w_street_1, w_street_2, w_city, w_state, w_zip, w_name from warehouse1 where w_id = :w_id
A B Diff
Execution Count 31511 N/A 0%
Execution Time 1009500 N/A 0%
Rows Returned 31511 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select w_street_1, w_street_2, w_city, w_state, w_zip, w_name from warehouse1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select w_street_1, w_street_2, w_city, w_state, w_zip, w_name from warehouse1 where w_id = :w_id", "Table": "warehouse1", "Values": [ ":w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select d_street_1, d_street_2, d_city, d_state, d_zip, d_name from district1 where d_w_id = :d_w_id and d_id = :d_w_id
A B Diff
Execution Count 3204 N/A 0%
Execution Time 991801 N/A 0%
Rows Returned 3204 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select d_street_1, d_street_2, d_city, d_state, d_zip, d_name from district1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select d_street_1, d_street_2, d_city, d_state, d_zip, d_name from district1 where d_w_id = :d_w_id and d_id = :d_w_id", "Table": "district1", "Values": [ ":d_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select d_street_1, d_street_2, d_city, d_state, d_zip, d_name from district1 where d_w_id = :d_w_id and d_id = :d_id
A B Diff
Execution Count 28307 N/A 0%
Execution Time 982050 N/A 0%
Rows Returned 28307 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select d_street_1, d_street_2, d_city, d_state, d_zip, d_name from district1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select d_street_1, d_street_2, d_city, d_state, d_zip, d_name from district1 where d_w_id = :d_w_id and d_id = :d_id", "Table": "district1", "Values": [ ":d_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(ol_amount) as sm from order_line1 where ol_o_id = :ol_o_id and ol_d_id = :ol_d_id and ol_w_id = :ol_w_id
A B Diff
Execution Count 27738 N/A 0%
Execution Time 937018 N/A 0%
Rows Returned 27738 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select sum(ol_amount) as sm from order_line1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select sum(ol_amount) as sm from order_line1 where ol_o_id = :ol_o_id and ol_d_id = :ol_d_id and ol_w_id = :ol_w_id", "Table": "order_line1", "Values": [ ":ol_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select o_c_id from orders1 where o_id = :o_id and o_d_id = :o_d_id and o_w_id = :o_d_id
A B Diff
Execution Count 3160 N/A 0%
Execution Time 934709 N/A 0%
Rows Returned 3160 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id and o_d_id = :o_d_id and o_w_id = :o_d_id", "Table": "orders1", "Values": [ ":o_d_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select i_price, i_name, i_data from item1 where i_id = :i_id
A B Diff
Execution Count 314190 N/A 0%
Execution Time 930444 N/A 0%
Rows Returned 314190 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select i_price, i_name, i_data from item1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select i_price, i_name, i_data from item1 where i_id = :i_id", "Table": "item1", "Values": [ ":i_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_01 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
A B Diff
Execution Count 32232 N/A 0%
Execution Time 911605 N/A 0%
Rows Returned 32232 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select s_quantity, s_data, s_dist_01 as s_dist from stock1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select s_quantity, s_data, s_dist_01 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update", "Table": "stock1", "Values": [ ":s_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_03 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
A B Diff
Execution Count 31995 N/A 0%
Execution Time 908692 N/A 0%
Rows Returned 31995 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select s_quantity, s_data, s_dist_03 as s_dist from stock1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select s_quantity, s_data, s_dist_03 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update", "Table": "stock1", "Values": [ ":s_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_02 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
A B Diff
Execution Count 31764 N/A 0%
Execution Time 908186 N/A 0%
Rows Returned 31764 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select s_quantity, s_data, s_dist_02 as s_dist from stock1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select s_quantity, s_data, s_dist_02 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update", "Table": "stock1", "Values": [ ":s_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_04 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
A B Diff
Execution Count 30537 N/A 0%
Execution Time 907182 N/A 0%
Rows Returned 30537 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select s_quantity, s_data, s_dist_04 as s_dist from stock1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select s_quantity, s_data, s_dist_04 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update", "Table": "stock1", "Values": [ ":s_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_05 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
A B Diff
Execution Count 30879 N/A 0%
Execution Time 904971 N/A 0%
Rows Returned 30879 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select s_quantity, s_data, s_dist_05 as s_dist from stock1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select s_quantity, s_data, s_dist_05 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update", "Table": "stock1", "Values": [ ":s_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_08 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
A B Diff
Execution Count 30349 N/A 0%
Execution Time 902061 N/A 0%
Rows Returned 30349 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select s_quantity, s_data, s_dist_08 as s_dist from stock1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select s_quantity, s_data, s_dist_08 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update", "Table": "stock1", "Values": [ ":s_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_07 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
A B Diff
Execution Count 31759 N/A 0%
Execution Time 901090 N/A 0%
Rows Returned 31759 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select s_quantity, s_data, s_dist_07 as s_dist from stock1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select s_quantity, s_data, s_dist_07 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update", "Table": "stock1", "Values": [ ":s_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_06 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
A B Diff
Execution Count 32130 N/A 0%
Execution Time 900319 N/A 0%
Rows Returned 32130 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select s_quantity, s_data, s_dist_06 as s_dist from stock1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select s_quantity, s_data, s_dist_06 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update", "Table": "stock1", "Values": [ ":s_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_10 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
A B Diff
Execution Count 31610 N/A 0%
Execution Time 899632 N/A 0%
Rows Returned 31610 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select s_quantity, s_data, s_dist_10 as s_dist from stock1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select s_quantity, s_data, s_dist_10 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update", "Table": "stock1", "Values": [ ":s_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_data from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_id
A B Diff
Execution Count 2871 N/A 0%
Execution Time 899394 N/A 0%
Rows Returned 2871 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_data from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_data from customer1 where c_w_id = :c_w_id and c_d_id = :c_d_id and c_id = :c_id", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_09 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update
A B Diff
Execution Count 30939 N/A 0%
Execution Time 899014 N/A 0%
Rows Returned 30939 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select s_quantity, s_data, s_dist_09 as s_dist from stock1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select s_quantity, s_data, s_dist_09 as s_dist from stock1 where s_i_id = :s_i_id and s_w_id = :s_w_id for update", "Table": "stock1", "Values": [ ":s_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_data from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_id
A B Diff
Execution Count 286 N/A 0%
Execution Time 891956 N/A 0%
Rows Returned 286 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select c_data from customer1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select c_data from customer1 where c_w_id = :c_w_id and c_d_id = :c_w_id and c_id = :c_id", "Table": "customer1", "Values": [ ":c_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select i_price, i_name, i_data from item1 where i_id = -:vtg1
A B Diff
Execution Count 322 N/A 0%
Execution Time 835307 N/A 0%
Rows Returned 0 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select i_price, i_name, i_data from item1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select i_price, i_name, i_data from item1 where i_id = -:vtg1", "Table": "item1", "Values": [ "-:vtg1" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select o_c_id from orders1 where o_id = :o_id and o_d_id = :o_d_id and o_w_id = :o_w_id
A B Diff
Execution Count 27738 N/A 0%
Execution Time 831485 N/A 0%
Rows Returned 27003 N/A 0%
Errors 0 N/A 0%
Query Plan A
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id and o_d_id = :o_d_id and o_w_id = :o_w_id", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select no_o_id from new_orders1 where no_d_id = :no_d_id /* INT64 */ and no_w_id = :no_d_id /* INT64 */ order by no_o_id asc limit :vtg1 /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select d_next_o_id, d_tax from district1 where d_w_id = :d_w_id /* INT64 */ and d_id = :d_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select d_next_o_id, d_tax from district1 where d_w_id = :d_w_id /* INT64 */ and d_id = :d_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select count(distinct s.s_i_id) from stock1 as s join order_line1 as ol on ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id where ol.ol_w_id = :ol_ol_w_id /* INT64 */ and ol.ol_d_id = :ol_ol_d_id /* INT64 */ and ol.ol_o_id < :ol_ol_o_id /* INT64 */ and ol.ol_o_id >= :ol_ol_o_id1 /* INT64 */ and s.s_w_id = :ol_ol_w_id /* INT64 */ and s.s_quantity < :ol_ol_d_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select count(distinct s.s_i_id) from stock1 as s join order_line1 as ol on ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id where ol.ol_w_id = :ol_ol_w_id /* INT64 */ and ol.ol_d_id = :ol_ol_w_id /* INT64 */ and ol.ol_o_id < :ol_ol_o_id /* INT64 */ and ol.ol_o_id >= :ol_ol_o_id1 /* INT64 */ and s.s_w_id = :ol_ol_w_id /* INT64 */ and s.s_quantity < :s_s_quantity /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select count(distinct s.s_i_id) from stock1 as s join order_line1 as ol on ol.ol_w_id = s.s_w_id and ol.ol_i_id = s.s_i_id where ol.ol_w_id = :ol_ol_w_id /* INT64 */ and ol.ol_d_id = :ol_ol_d_id /* INT64 */ and ol.ol_o_id < :ol_ol_o_id /* INT64 */ and ol.ol_o_id >= :ol_ol_o_id1 /* INT64 */ and s.s_w_id = :ol_ol_w_id /* INT64 */ and s.s_quantity < :s_s_quantity /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_d_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_c_id = :o_w_id /* INT64 */ order by o_id desc
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :w_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_id = :c_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_c_id = :o_d_id /* INT64 */ order by o_id desc
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_08 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_i_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_d_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_d_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select no_o_id from new_orders1 where no_d_id = :no_d_id /* INT64 */ and no_w_id = :no_w_id /* INT64 */ order by no_o_id asc limit :vtg1 /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_discount, c_last, c_credit, w_tax from customer1 as c join warehouse1 as w on c_w_id = w_id where w_id = :w_id /* INT64 */ and c_d_id = :w_id /* INT64 */ and c_id = :c_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_balance, c_first, c_middle, c_last from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_id = :c_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_id = :c_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select d_next_o_id from district1 where d_id = :d_id /* INT64 */ and d_w_id = :d_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select d_next_o_id from district1 where d_id = :d_id /* INT64 */ and d_w_id = :d_w_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_since from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_balance, c_first, c_middle, c_id from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_last = :c_last /* VARCHAR */ order by c_first asc
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_balance, c_first, c_middle, c_id from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_last = :c_last /* VARCHAR */ order by c_first asc
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select count(c_id) as namecnt from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_last = :c_last /* VARCHAR */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select count(c_id) as namecnt from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_last = :c_last /* VARCHAR */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_c_id = :o_c_id /* INT64 */ order by o_id desc
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select o_id, o_carrier_id, o_entry_d from orders1 where o_w_id = :o_w_id /* INT64 */ and o_d_id = :o_w_id /* INT64 */ and o_c_id = :o_c_id /* INT64 */ order by o_id desc
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d from order_line1 where ol_w_id = :ol_w_id /* INT64 */ and ol_d_id = :ol_d_id /* INT64 */ and ol_o_id = :ol_d_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_delivery_d from order_line1 where ol_w_id = :ol_w_id /* INT64 */ and ol_d_id = :ol_w_id /* INT64 */ and ol_o_id = :ol_w_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_id from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_last = :c_last /* VARCHAR */ order by c_first asc
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_id from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_last = :c_last /* VARCHAR */ order by c_first asc
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(ol_amount) as sm from order_line1 where ol_o_id = :ol_o_id /* INT64 */ and ol_d_id = :ol_d_id /* INT64 */ and ol_w_id = :ol_d_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select w_street_1, w_street_2, w_city, w_state, w_zip, w_name from warehouse1 where w_id = :w_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select d_street_1, d_street_2, d_city, d_state, d_zip, d_name from district1 where d_w_id = :d_w_id /* INT64 */ and d_id = :d_w_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select d_street_1, d_street_2, d_city, d_state, d_zip, d_name from district1 where d_w_id = :d_w_id /* INT64 */ and d_id = :d_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_d_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select i_price, i_name, i_data from item1 where i_id = :i_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select sum(ol_amount) as sm from order_line1 where ol_o_id = :ol_o_id /* INT64 */ and ol_d_id = :ol_d_id /* INT64 */ and ol_w_id = :ol_w_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_03 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_04 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_02 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_data from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_w_id /* INT64 */ and c_id = :c_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_01 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_05 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_06 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_09 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_10 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select c_data from customer1 where c_w_id = :c_w_id /* INT64 */ and c_d_id = :c_d_id /* INT64 */ and c_id = :c_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_07 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select s_quantity, s_data, s_dist_08 as s_dist from stock1 where s_i_id = :s_i_id /* INT64 */ and s_w_id = :s_w_id /* INT64 */ for update
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select i_price, i_name, i_data from item1 where i_id = -:vtg1 /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }
Statistics
Query select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */
A B Diff
Execution Count N/A 28035 0%
Execution Time N/A 833453 0%
Rows Returned N/A 27144 0%
Errors N/A 0 0%
Query Plan B
{ "FieldQuery": "select o_c_id from orders1 where 1 != 1", "Keyspace": { "Name": "main", "Sharded": true }, "OperatorType": "Route", "Query": "select o_c_id from orders1 where o_id = :o_id /* INT64 */ and o_d_id = :o_d_id /* INT64 */ and o_w_id = :o_w_id /* INT64 */", "Table": "orders1", "Values": [ ":o_w_id" ], "Variant": "EqualUnique", "Vindex": "hash" }