Album » OptB » q4  (7 Slides)     [Page 1 of 1] :: Jump To  
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

  Up one level  
plan_diag * Plan Diagram * 1254 x 773 * (151KB)
reduced_diag * 1253 x 785 * (145KB)
cost_diag * Plan Cost Diagram * 1254 x 773 * (175KB)
card_diag * Plan Cardinality Diagram * 1254 x 773 * (170KB)
plan1 * PLAN 1 * 1254 x 867 * (29KB)
  plan_diag  
  reduced_diag  
  cost_diag  
  card_diag  
  plan1  
plan2 * PLAN 2 * 1243 x 867 * (29KB)
plan3 * PLAN 3 * 1243 x 867 * (31KB)
  plan2  
  plan3  
Album last updated on 5/19/07 12:53 AM
Powered by JAlbum 7.1 and BluPlusPlus skin