Directives Examples : INDEX

QUERY:

------

select --+ ordered index(customer, zip_ix) avoid_index(orders," 101_4")

customer.lname, orders.order_num, items.total_price

from customer c, orders o, items i

where c.customer_num = o.customer_num

and o.order_num = i.order_num

and stock_num = 6 and manu_code = "SMT"

Previous slide

Next slide

Back to first slide

View graphic version