q20

select
    s_name,
    s_address
from
    supplier,
    nation
where
    s_suppkey in (
        select
            ps_suppkey
        from
            partsupp
        where
            ps_partkey in (
                select
                    p_partkey
                from
                    part
                where
                    p_name like 'forest%'
            )
            and ps_availqty < (
                select
                    0.5 * sum(l_quantity)
                from
                    lineitem
                where
                    l_partkey = ps_partkey
                    and l_suppkey = ps_suppkey
                    and l_extendedprice :varies

            )
    )
    and s_nationkey = n_nationkey
    and s_acctbal :varies
    and n_name = 'AMERICA'
order by
    s_name

plan_diag

reduced_diag

cost_diag

card_diag

plan1

Album last updated on 5/19/07 1:07 AM