The purpose of this assignment is to practice using indexing appropriately. The ability to evaluate and implement various storage structures, index selections, and views is an important aspect of database management. Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy. Create a Word document that includes the SQL query code used to explore the database tables and answer the following questions. You notice when running queries that the database is returning results very slowly. Discuss likely causes for the slow returns. Propose solutions for speeding the process. Include specific explanation that details why implementing the proposed solutions will speed returns. Discuss two indexing issues that can negatively affect databases. Provide specific examples in your discussion. The sales manager has received a customer request that all products be searchable according to color specifications. In this particular case, the customer is seeking on red products. Build a view consisting of ProductID, Product, and Color, and query the new view. The sales manager presented the customer with the view you created in question 3. The customer is still unhappy with the product list because many of the items were not available for bulk purchase or were not yet in storage, which resulted in delays. To address the problem, rebuild the view with multiple joins and add the parameter for "Finished Goods Storage" in the Location table. Bring in the "Quantity" field from the Inventory table. Rerun the query in the view.