Correlated Sub-queries: Rewritten CSQ

QUERY:

update orders set ship_charge = 0

where customer_num in (

select customer_num from customer c

where c.state = "MD” )

1) informix.orders: INDEX PATH

(1) Index Keys: customer_num

Lower Index Filter:orders.customer_num = ANY <subquery>

Subquery:

---------

1) informix.c: SEQUENTIAL SCAN

Filters: informix.c.state = 'MD'

Previous slide

Next slide

Back to first slide

View graphic version