Consider the following query on the table Customers in SH schema and answer the following questions:...

 

Transcribed Image Text:

Consider the following query on the table Customers in SH schema and answer the following questions: select c.* from customers c where cust_first name='Abigail' and CUST_YEAR_OF_BIRTH = '1977' ; a. Please identify at least TWO (2) prospective performance issues in the above query? b. Suggest how above query can be modified and what indexes (including column names and index types) should be created to improve its performance. c. Give also Create index statements Consider the following query on the table Customers in SH schema and answer the following questions: select c.* from customers c where cust_first name='Abigail' and CUST_YEAR_OF_BIRTH = '1977' ; a. Please identify at least TWO (2) prospective performance issues in the above query? b. Suggest how above query can be modified and what indexes (including column names and index types) should be created to improve its performance. c. Give also Create index statements

Answer rating: 100% (QA)

The image contains a SQL query with instructions to comment on it Lets address each instruction step ... View the full answer