Sample Picasso Diagrams - QT14

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 1129 * (143KB)

Reduced Diagram (20%) * 1920 x 1129 * (142KB)

Cardinality Diagram * 1920 x 1129 * (138KB)

Cost Diagram * 1920 x 1129 * (138KB)

Plan1 * 1936 x 1186 * (108KB)

Reduced Diagram (20%)

Cardinality Diagram

Plan2 * 1936 x 1186 * (108KB)

Plan3 * 1920 x 1200 * (107KB)

Album last updated on 2/9/09 9:59 PM

Powered by and skin

Indian Institute of Science