Sample Picasso Diagrams » QT13  (6 Slides)     [Page 1 of 1] :: Jump To  
Query Template

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

Optimizer Diagrams
  Up one level  
Plan Diagram * 1919 x 1125 * (90KB)
Reduced Diagram (20%) * 1919 x 1125 * (91KB)
Cardinality Diagram * 1919 x 1125 * (90KB)
Cost Diagram * 1919 x 1125 * (91KB)
Plan1 * 1919 x 1125 * (65KB)
  Plan Diagram  
  Reduced Diagram (20%)  
  Cardinality Diagram  
  Cost Diagram  
  Plan1  
Plan2 * 1919 x 1125 * (63KB)
  Plan2  
Album last updated on 2/9/09 9:59 PM
Powered by Jalbum 8.1 and BluPlusPlus skin
Indian Institute of Science