Question: 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
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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
