Based on the ER model shown in Figure P11.7 and on the query shown after the figure.

Figure P11.7:

Given the following query

SELECT        P_CODE, P_PRICE 

FROM          PRODUCT

WHERE        P_PRICE >= (SELECT AVG(P_PRICE) FROM PRODUCT);

Assuming that there are no table statistics, what type of optimization will the DBMS use?

Transcribed Image Text:

INVOICE CUSTOMER LINE PK Cus CODE PK INV_NUMBER PK,FK1 INV_NUMBER LINE_NUMBER contains generates FK1 Cus CODE INV DATE Cus_LNAME cus_FNAME Cus_INITIAL Cus AREACODE cus PHONE Cus BALANCE FK2 P_CODE LINE_UNITS LINE_PRICE is found i VENDOR PRODUCT | Pк |у соDE PK P CODE V_NAME V_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER P_DESCRIPT P_INDATE P_QOH P_MIN P_PRICE P_DISCOUNT V_CODE supplies FK1