, 2012 5:20 PM
To: mysql@lists.mysql.com
Subject: Re: forcing mysql to use batched key access (BKA) optimization for
joins
>>>> 2012/04/10 15:58 -0400, Stephen Tu >>>>
select
c_custkey,
c_name,
sum(l_extendedprice * (100 - l_discount)) as revenue,
c_acctba
Hi Stephen,
2012/04/10 15:58 -0400, Stephen Tu
>| id | select_type | table| type | possible_keys | key
>| key_len | ref | rows|
>Extra |
>++-+--++-
2012/04/10 15:58 -0400, Stephen Tu
select
c_custkey,
c_name,
sum(l_extendedprice * (100 - l_discount)) as revenue,
c_acctbal,
n_name,
c_address,
c_phone,
c_comment
from CUSTOMER_INT, ORDERS_INT, LINEITEM_INT, NATION_INT
where
c_custkey = o_custkey
and l_orderke
