Sample Picasso Diagrams » QT4  (8 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 * (164KB)
Reduced Diagram (20%) * 1920 x 1170 * (157KB)
Cardinality Diagram * 1920 x 1170 * (160KB)
Cost Diagram * 1920 x 1170 * (166KB)
Plan1 * 1920 x 1170 * (105KB)
  Plan Diagram  
  Reduced Diagram (20%)  
  Cardinality Diagram  
  Cost Diagram  
  Plan1  
Plan2 * 1920 x 1170 * (105KB)
Plan3 * 1920 x 1170 * (107KB)
Plan4 * 1920 x 1170 * (101KB)
  Plan2  
  Plan3  
  Plan4  
Album last updated on 2/9/09 9:58 PM
Powered by Jalbum 8.1 and BluPlusPlus skin
Indian Institute of Science