Case Project 7-2: X-Tex In your role as the database administrator for X-Tex, a small but successful company that designs and manufactures high-tech fabrics, you have been asked to help optimize a that will provide a dynamic view of your supply chain. You are to work with a developer who is tasked with integrating the data into a Web portal that is used by the manufacturing operations team. The developer explains that he has not had much experience working with SQL, but he seems keen to learn. Complete the following: . Provide the developer with a practical summary of design considerations that will help to ensure that the query performs well The developer has specified that he needs the result set to be sorted. Explain the possible performance ramifications of sorting the result set, and suggest an alternative. . Explain how you can test a rototype query to hne-tune its performance characteristics to fine-tu