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

select
    l_extendedprice * (1 - l_discount)
from
    lineitem,
    part
where
    l_partkey = p_partkey
    and l_extendedprice :varies
    and p_retailprice :varies

Optimizer Diagrams
  Up one level  
Plan Diagram * 1920 x 1170 * (154KB)
Reduced Diagram (20%) * 1920 x 1170 * (152KB)
Cardinality Diagram * 1920 x 1170 * (155KB)
Cost Diagram * 1920 x 1170 * (153KB)
Plan1 * 1920 x 1170 * (102KB)
  Plan Diagram  
  Reduced Diagram (20%)  
  Cardinality Diagram  
  Cost Diagram  
  Plan1  
Plan2 * 1920 x 1170 * (102KB)
  Plan2  
Album last updated on 2/9/09 9:58 PM
Powered by Jalbum 8.1 and BluPlusPlus skin
Indian Institute of Science