Role as the database administrator
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 query 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 to be used by the manufacturing operations team. The developer explains that he does not have much experience working with SQL Server 2012, but he seems keen to learn. Please provide the developer with a practical summary of design considerations that will help to ensure the query performs well.