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

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

Optimizer Diagrams
  Up one level  
Plan Diagram * 1920 x 1129 * (122KB)
Reduced Diagram (20%) * 1920 x 1129 * (118KB)
Cardinality Diagram * 1920 x 1129 * (125KB)
Cost Diagram * 1920 x 1129 * (125KB)
Plan1 * 1936 x 1186 * (98KB)
  Plan Diagram  
  Reduced Diagram (20%)  
  Cardinality Diagram  
  Cost Diagram  
  Plan1  
Plan2 * 1936 x 1186 * (99KB)
Plan3 * 1936 x 1186 * (97KB)
  Plan2  
  Plan3  
Album last updated on 2/9/09 9:58 PM
Powered by Jalbum 8.1 and BluPlusPlus skin
Indian Institute of Science