Album » OptB » q13  (6 Slides)     [Page 1 of 1] :: Jump To  
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
    )
group by
    c_count
order by
    custdist desc,
    c_count desc

  Up one level  
plan_diag * Plan Diagram * 1254 x 773 * (119KB)
reduced_diag * 1253 x 785 * (112KB)
cost_diag * Plan Cost Diagram * 1254 x 773 * (136KB)
card_diag * Plan Cardinality Diagram * 1254 x 773 * (130KB)
plan1 * PLAN 1 * 1254 x 867 * (37KB)
  plan_diag  
  reduced_diag  
  cost_diag  
  card_diag  
  plan1  
plan2 * PLAN 2 * 1243 x 867 * (37KB)
  plan2  
Album last updated on 5/19/07 12:55 AM
Powered by JAlbum 7.1 and BluPlusPlus skin