Sample Picasso Diagrams - QT14

Query Template

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

Optimizer Diagrams

Up one level

Plan Diagram * 1920 x 1129 * (142KB)

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

caard_diag * 1920 x 1129 * (139KB)

Cost Diagram * 1920 x 1129 * (139KB)

Plan1 * 1936 x 1186 * (108KB)

Reduced Diagram (20%)

Plan2 * 1936 x 1186 * (107KB)

Plan3 * 1936 x 1186 * (110KB)

Plan4 * 1936 x 1186 * (108KB)

Plan5 * 1936 x 1186 * (107KB)

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

Powered by and skin

Indian Institute of Science