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

select
    o_orderpriority,
    count(*) as order_count
from
    orders
where
    o_totalprice :varies
    and exists (
        select *
        from
            lineitem
        where
            l_orderkey = o_orderkey
            and l_extendedprice :varies
    )
group by
    o_orderpriority
order by
    o_orderpriority

Optimizer Diagrams
  Up one level  
Plan Diagram * 1920 x 1170 * (153KB)
Reduced Diagram (20%) * 1920 x 1170 * (157KB)
Cardinality Diagram * 1920 x 1170 * (157KB)
Cost Diagram * 1920 x 1170 * (160KB)
Plan1 * 1936 x 1186 * (104KB)
  Plan Diagram  
  Reduced Diagram (20%)  
  Cardinality Diagram  
  Cost Diagram  
  Plan1  
Plan2 * 1936 x 1186 * (101KB)
Plan3 * 1936 x 1186 * (98KB)
Plan4 * 1936 x 1186 * (98KB)
Plan5 * 1936 x 1186 * (97KB)
Plan6 * 1936 x 1186 * (105KB)
  Plan2  
  Plan3  
  Plan4  
  Plan5  
  Plan6  
Plan7 * 1920 x 1200 * (93KB)
  Plan7  
Album last updated on 2/9/09 9:57 PM
Powered by Jalbum 8.1 and BluPlusPlus skin
Indian Institute of Science