Directives Examples : INDEX (cont.)

DIRECTIVES FOLLOWED:

ORDERED

INDEX ( customer zip_ix )

AVOID_INDEX ( orders 101_4 )

DIRECTIVES NOT FOLLOWED:

1)customer: INDEX PATH

(1) Index Keys: zipcode

2)orders: SEQUENTIAL SCAN

DYNAMIC HASH JOIN (Build Outer)

Dynamic Hash Filters:c.customer_num =o.customer_num

3)items: INDEX PATH

Filters:i.order_num =o.order_num

(1) Index Keys: stock_num manu_code

Lower Index Filter: (i.stock_num = 6 AND i.manu_code = 'SMT' )

NESTED LOOP JOIN

Previous slide

Next slide

Back to first slide

View graphic version