1. Engineering
  2. Computer Science
  3. 2 discuss two indexing issues that can negatively affect databases...

Question: 2 discuss two indexing issues that can negatively affect databases...

Question details

2. Discuss two indexing issues that can negatively affect databases. Provide specific examples in your discussion. 3. 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 red products. Build a view consisting of ProductID, Product, and Color, and query the new view. 4. 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. Question 1 I understand and can figure out question 2, but 3 and 4 is where I am stumped on.

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution