Directives Examples: ORDERED

QUERY:

select --+ ordered

customer.lname, orders.order_num, items.total_price

from customer, orders, items

where customer.customer_num = orders.customer_num

and orders.order_num = items.order_num

and items.stock_num = 6 and items.manu_code = "SMT"

DIRECTIVES FOLLOWED:

ORDERED

DIRECTIVES NOT FOLLOWED:

1) customer: SEQUENTIAL SCAN

2) orders: INDEX PATH

(1) Index Keys: customer_num

Lower Index Filter: orders.customer_num =customer.customer_num

NESTED LOOP JOIN

3) items: INDEX PATH

Filters: items.order_num = orders.order_num

(1) Index Keys: stock_num manu_code

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

NESTED LOOP JOIN

Previous slide

Next slide

Back to first slide

View graphic version