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

SELECT
    C_CUSTKEY,
    C_NAME,
    SUM(L_EXTENDEDPRICE * (1 - L_DISCOUNT)) AS REVENUE,
    C_ACCTBAL,
    N_NAME,
    C_ADDRESS,
    C_PHONE,
    C_COMMENT
FROM
    CUSTOMER,
    ORDERS,
    LINEITEM,
    NATION
WHERE
    C_CUSTKEY = O_CUSTKEY
    AND L_ORDERKEY = O_ORDERKEY
    AND O_ORDERDATE >= '1993-10-01'
    AND O_ORDERDATE < '1994-01-01'
    AND C_NATIONKEY = N_NATIONKEY
    AND C_ACCTBAL :varies
    AND L_EXTENDEDPRICE :varies
GROUP BY
    C_CUSTKEY,
    C_NAME,
    C_ACCTBAL,
    C_PHONE,
    N_NAME,
    C_ADDRESS,
    C_COMMENT
ORDER BY
    REVENUE DESC

Optimizer Diagrams
  Up one level  
Plan Diagram * 1920 x 1129 * (149KB)
Reduced Diagram (20%) * 1920 x 1129 * (133KB)
Cardinality Diagram * 1920 x 1129 * (146KB)
Cost Diagram * 1920 x 1129 * (147KB)
Plan1 * 1936 x 1186 * (104KB)
  Plan Diagram  
  Reduced Diagram (20%)  
  Cardinality Diagram  
  Cost Diagram  
  Plan1  
Plan10 * 1936 x 1186 * (104KB)
Plan2 * 1936 x 1186 * (103KB)
Plan3 * 1936 x 1186 * (104KB)
Plan4 * 1936 x 1186 * (103KB)
Plan5 * 1936 x 1186 * (103KB)
  Plan10  
  Plan2  
  Plan3  
  Plan4  
  Plan5  
Plan6 * 1936 x 1186 * (103KB)
Plan7 * 1936 x 1186 * (104KB)
Plan8 * 1936 x 1186 * (104KB)
Plan9 * 1936 x 1186 * (106KB)
  Plan6  
  Plan7  
  Plan8  
  Plan9  
Album last updated on 2/9/09 9:59 PM
Powered by Jalbum 8.1 and BluPlusPlus skin
Indian Institute of Science