q13

select
    c_count,
    count(*) as custdist
from
    ( select
        c_custkey,
        count(o_orderkey) as c_count
     from
        customer left outer join orders on
            c_custkey = o_custkey
            and o_totalprice :varies
     group by
        c_custkey
    ) as c_orders
group by
    c_count
order by
    custdist desc,
    c_count desc

Up one level

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

reduced_diag * 1255 x 773 * (111KB)

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

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

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

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

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

plan4 * PLAN 4 * 1252 x 871 * (37KB)

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

Powered by and skin