In your role as the database administrator for a company, you have been asked to help optimize a query. 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.
Note: (200-300 words, with a reference, properly cited) Does not need to be in APA format.
English only!!! If English is not your first language, do not bid on this assignment please. Thanks.