Sample Picasso Diagrams » QT4  (5 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 * 1919 x 1125 * (93KB)
Reduced Diagram (20%) * 1919 x 1125 * (94KB)
Cardinality Diagram * 1919 x 1125 * (93KB)
Cost Diagram * 1919 x 1125 * (95KB)
Plan1 * 1919 x 1125 * (59KB)
  Plan Diagram  
  Reduced Diagram (20%)  
  Cardinality Diagram  
  Cost Diagram  
  Plan1  
Album last updated on 2/9/09 9:58 PM
Powered by Jalbum 8.1 and BluPlusPlus skin
Indian Institute of Science