Sample Picasso Diagrams » QT4  (16 Slides)     [Page 1 of 2] :: 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
  You have reached the first page You have reached the first page      Up one level      Next page Last page  
Plan Diagram * 1920 x 1170 * (194KB)
Reduced Diagram (20%) * 1920 x 1170 * (187KB)
Cardinality Diagram * 1920 x 1170 * (171KB)
Cost Diagram * 1920 x 1170 * (173KB)
Plan1 * 1936 x 1186 * (102KB)
  Plan Diagram  
  Reduced Diagram (20%)  
  Cardinality Diagram  
  Cost Diagram  
  Plan1  
Plan2 * 1936 x 1186 * (100KB)
Plan3 * 1936 x 1186 * (98KB)
Plan4 * 1936 x 1186 * (102KB)
Plan5 * 1936 x 1186 * (99KB)
Plan6 * 1936 x 1186 * (98KB)
  Plan2  
  Plan3  
  Plan4  
  Plan5  
  Plan6  
Plan7 * 1936 x 1186 * (100KB)
Plan8 * 1936 x 1186 * (97KB)
Plan9 * 1936 x 1186 * (99KB)
Plan10 * 1936 x 1186 * (102KB)
Plan11 * 1936 x 1186 * (102KB)
  Plan7  
  Plan8  
  Plan9  
  Plan10  
  Plan11  
Album last updated on 2/9/09 9:58 PM
Powered by Jalbum 8.1 and BluPlusPlus skin
Indian Institute of Science