Sample Picasso Diagrams » QT4  (9 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 = ORDERS.O_ORDERKEY
            AND L_EXTENDEDPRICE :varies
    )
GROUP BY
    O_ORDERPRIORITY
ORDER BY
    O_ORDERPRIORITY

Optimizer Diagrams
  Up one level  
Plan Diagram * 1920 x 1129 * (136KB)
Reduced Diagram (20%) * 1920 x 1129 * (134KB)
Cardinality Diagram * 1920 x 1129 * (140KB)
Cost Diagram * 1920 x 1129 * (143KB)
Plan1 * 1936 x 1186 * (104KB)
  Plan Diagram  
  Reduced Diagram (20%)  
  Cardinality Diagram  
  Cost Diagram  
  Plan1  
Plan2 * 1936 x 1186 * (99KB)
Plan3 * 1936 x 1186 * (99KB)
Plan4 * 1936 x 1186 * (98KB)
Plan5 * 1936 x 1186 * (104KB)
  Plan2  
  Plan3  
  Plan4  
  Plan5  
Album last updated on 2/9/09 9:59 PM
Powered by Jalbum 8.1 and BluPlusPlus skin
Indian Institute of Science