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


SELECT
    C_NAME,
    C_CUSTKEY,
    O_ORDERKEY,
    O_ORDERDATE,
    O_TOTALPRICE,
    SUM(L_QUANTITY)
FROM
    CUSTOMER,
    ORDERS,
    LINEITEM
WHERE
    O_ORDERKEY IN (
        SELECT
            L_ORDERKEY
        FROM
            LINEITEM
        WHERE L_EXTENDEDPRICE :varies
        GROUP BY
            L_ORDERKEY HAVING
                SUM(L_QUANTITY) > 300
    )
    AND C_CUSTKEY = O_CUSTKEY
    AND O_ORDERKEY = L_ORDERKEY
    AND C_ACCTBAL :varies
GROUP BY
    C_NAME,
    C_CUSTKEY,
    O_ORDERKEY,
    O_ORDERDATE,
    O_TOTALPRICE
ORDER BY
    O_TOTALPRICE DESC,
    O_ORDERDATE

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