q17

select
    sum(l_extendedprice) / 7.0 as avg_yearly
from
    lineitem,
    part
where
    p_partkey = l_partkey
    and p_retailprice :varies
    and l_quantity < (
        select
            0.2 * avg(l_quantity)
        from
            lineitem
        where
            l_partkey = p_partkey
            and l_extendedprice :varies
    )

Up one level

plan_diag * Plan Diagram * 1277 x 769 * (146KB)

reduced_diag * 1255 x 773 * (138KB)

cost_diag * Plan Cost Diagram * 1277 x 769 * (174KB)

card_diag * Plan Cardinality Diagram * 1277 x 769 * (172KB)

plan1 * PLAN 1 * 1252 x 871 * (32KB)

plan2 * PLAN 2 * 1252 x 871 * (34KB)

plan3 * PLAN 3 * 1252 x 871 * (36KB)

Album last updated on 5/19/07 12:51 AM

Powered by and skin