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 * 1252 x 777 * (197KB)

reduced_diag * 1249 x 778 * (161KB)

cost_diag * Plan Cost Diagram * 1252 x 777 * (221KB)

card_diag * Plan Cardinality Diagram * 1252 x 777 * (216KB)

plan1 * PLAN 1 * 1250 x 870 * (42KB)

plan2 * PLAN 2 * 1250 x 870 * (44KB)

plan3 * PLAN 3 * 1250 x 870 * (42KB)

plan4 * PLAN 4 * 1250 x 870 * (44KB)

plan5 * PLAN 5 * 1250 x 870 * (42KB)

plan6 * PLAN 6 * 1250 x 870 * (43KB)

plan7 * PLAN 7 * 1248 x 869 * (43KB)

plan8 * PLAN 8 * 1248 x 866 * (43KB)

plan9 * PLAN 9 * 1252 x 869 * (42KB)

plan10 * PLAN 10 * 1250 x 870 * (44KB)

plan11 * PLAN 11 * 1250 x 870 * (43KB)

plan12 * PLAN 12 * 1250 x 870 * (43KB)

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

Powered by and skin