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
    )
group by
    c_count
order by
    custdist desc,
    c_count desc

Optimizer Diagrams
  Up one level  
Plan Diagram * 1920 x 1170 * (137KB)
Reduced Diagram (20%) * 1920 x 1170 * (135KB)
Cardinality Diagram * 1920 x 1170 * (144KB)
Cost Diagram * 1920 x 1170 * (143KB)
Plan1 * 1920 x 1170 * (95KB)
  Plan Diagram  
  Reduced Diagram (20%)  
  Cardinality Diagram  
  Cost Diagram  
  Plan1  
Plan2 * 1920 x 1170 * (97KB)
  Plan2  
Album last updated on 2/9/09 9:58 PM
Powered by Jalbum 8.1 and BluPlusPlus skin
Indian Institute of Science