Album » OptA » q4  (12 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 = o_orderkey
            and l_extendedprice :varies
    )
group by
    o_orderpriority
order by
    o_orderpriority

Pictures
  Up one level  
plan_diag * Plan Diagram * 1277 x 769 * (168KB)
reduced_diag * 1255 x 773 * (155KB)
cost_diag * Plan Cost Diagram * 1277 x 769 * (210KB)
card_diag * Plan Cardinality Diagram * 1277 x 769 * (194KB)
plan1 * PLAN 1 * 1252 x 871 * (41KB)
  plan_diag  
  reduced_diag  
  cost_diag  
  card_diag  
  plan1  
plan2 * PLAN 2 * 1252 x 871 * (39KB)
plan3 * PLAN 3 * 1252 x 871 * (40KB)
plan4 * PLAN 4 * 1252 x 871 * (42KB)
plan5 * PLAN 5 * 1252 x 871 * (34KB)
plan6 * PLAN 6 * 1252 x 871 * (34KB)
  plan2  
  plan3  
  plan4  
  plan5  
  plan6  
plan7 * PLAN 7 * 1252 x 871 * (39KB)
plan8 * PLAN 8 * 1252 x 871 * (39KB)
  plan7  
  plan8  
Album last updated on 5/19/07 12:47 AM
Powered by JAlbum 7.1 and BluPlusPlus skin