Directives Examples : Errors

QUERY:

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

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 stock_num = 6 and manu_code = "SMT"

DIRECTIVES FOLLOWED:

ORDERED

INDEX ( customer zip_ix )

DIRECTIVES NOT FOLLOWED:

AVOID_INDEX( orders 222_4 ) Invalid Index Name Specified.

Previous slide

Next slide

Back to first slide

View graphic version