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) 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 * 1920 x 1170 * (137KB)
Reduced Diagram (20%) * 1920 x 1170 * (134KB)
Cardinality Diagram * 1920 x 1170 * (140KB)
Cost Diagram * 1920 x 1170 * (140KB)
Plan1 * 1936 x 1186 * (96KB)
  Plan Diagram  
  Reduced Diagram (20%)  
  Cardinality Diagram  
  Cost Diagram  
  Plan1  
Plan2 * 1936 x 1186 * (96KB)
Plan3 * 1936 x 1186 * (96KB)
  Plan2  
  Plan3  
Album last updated on 2/9/09 9:57 PM
Powered by Jalbum 8.1 and BluPlusPlus skin
Indian Institute of Science