Question: Based on the following query: SELECT P_CODE, P_DESCRIPT, P_PRICE, PRODUCT.V_CODE, V_STATE FROM PRODUCT P, VENDOR V WHERE P.V_CODE = V.V_CODE AND V_STATE = NY AND

Based on the following query:

SELECT        P_CODE, P_DESCRIPT, P_PRICE, PRODUCT.V_CODE, V_STATE

FROM          PRODUCT P, VENDOR V

WHERE        P.V_CODE = V.V_CODE

     AND        V_STATE = ‘NY’

     AND        V_AREACODE = ‘212’;

ORDER BY   P_PRICE;


What indexes would you recommend?

Step by Step Solution

★★★★★

3.42 Rating (180 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

This query uses the VSTATE and VAREACODE attrib... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Database Concepts Questions!

Q:

Based on the following query: SELECT P_CODE, SUM(LINE_UNITS) FROM LINE GROUP BY P_CODE HAVING SUM(LINE_UNITS) > (SELECT MAX(LINE_UNITS) FROM LINE); Write the command to create statistics for this...

Q:

Based on the following query: SELECT P_CODE, P_QOH*P_PRICE FROM PRODUCT WHERE P_QOH*P_PRICE > (SELECT AVG(P_QOH*P_PRICE) FROM PRODUCT) What is the likely data sparsity of the P_QOH and P_PRICE...

Q:

Based on the following query: SELECT V_CODE, V_NAME, V_CONTACT, V_STATE FROM VENDOR WHERE V_STATE = TN ORDER BY V_NAME; Assume that 10,000 vendors are distributed as shown in Table P11.18. What...

Q:

I can run these individual but when I run them all at a time, it only completes a few in oracle. What do I need to fix this. /* 1 */ Select * from PRODUCT where P_DESCRIPT like '%saw%' /* 2 */ Select...

Q:

Problems 2 2 - 2 4 are based on the following query: SELECT FROM WHERE P _ CODE, _ DESCRIPT, P _ PRICE, P . V _ CODE, V _ STATE PRODUCT P , VENDOR V P . V _ CODE = V . V _ CODE AND V _ STATE = NY AND...

Q:

Use the SaleCo ERD listed below and the provided SQL scripts to construct its relational database and answer the following queries. Write a query to count the number of invoices. Write a query to...

Q:

16. The external model yields some advantages such as ______________ a. use of the database subsets to make application program development much simpler. b. use of the database subsets to make...

Q:

5. List the customers who have ordered product bearing product code 23109-HB. Display first names, last names of customers, invoice numbers and product codes. 6. Display Vendor details (V_CODE,...

Q:

The structure and contents of the Ch07_SaleCo database are shown in Figure P7.9 . Use this database to answer the following problems. 9. Write a query to count the number of invoices. 10. Write a...

Q:

This is a sample of the query but it's not correct the mistake I get is Invalid use of group function. select CONCAT(C.CUS_FNAME ,' ) 'CUS_FNAME , ROUND SUMCP.P_PRICE ) ) 'Total Money Spent from...

Q:

Nevada, Inc. reported the following items in the 2017 pension footnote (in millions). Service cost $1,171 Benefits paid to retirees 186 Interest cost 930 Actual returns on invested assets 1,204...

Q:

A person can be an employee, alumnus or a student. For person P_id (identifier), date of birth, gender and contacts are stored. Person can have more than one contact numbers and there are no other...

Q:

Al Long Ford sells Katrina, age 1 6 , a Ford Escape under a contract that states Katrina will pay Ford $ 8 0 0 per month for the next 3 6 months. The contract has a clause explaining that if Katrina...

Q:

Progress reports describe what the project team has accomplished during a certain period. In many projects, each team member prepares a weekly or monthly progress report. Team leaders often create...

Q:

One of the purchasing managers is interested in the impact of product prices on the sale of products of each brand. Write a query to display the brand name, brand type, average price of products of...

Q:

The purchasing manager is still concerned about the impact of price on sales. Write a query to display the brand name, brand type, product SKU, product description, and price of any products that are...

Q:

Create a stored procedure named prc_inv_amounts to update the INV_SUBTOTAL, INV_TAX, and INV_TOTAL. The procedure takes the invoice number as a parameter. The INV_SUBTOTAL is the sum of the...

Q:

a) Joe verbally agreed with his landlord to a two-year lease for an apartment. Only five months later, the property was sold to somebody else. The new owners gave Joe three months to vacate the...

Q:

A client invests $ 1 , 0 0 0 every month, at the beginning of the month, beginning one month from today, for the next twenty five years. The account is expected to earn 4 . 3 5 % , compounded...

Q:

What are the three common Boolean operators used to structure a search?