Get Help With Homework paper: Explain how one can test a prototype query to fine-tune its performance characteristics.
You work for a manufacturing company. The company has recently hired a programmer who does not have knowledge of SQL Server, but has been tasked to develop queries. As a database administrator, you have been tasked with the following to help him/her out with understanding queries and performance. Address the following in your discussion posts:
- What design considerations will the developer need to be aware of to ensure queries are optimized? Why?
- What should the developer be aware of when sorting data in a result set? Why?
- Explain how one can test a prototype query to fine-tune its performance characteristics.
