In organizations that operate without a data warehouse or separate analytical database for reporting, the only source of the latest and up-to-date data may be in the live production database. When querying a production database, optimization is key. An inefficient query may pose a burden on the production database’s resources, and cause slow performance or loss of service for other users if the query contains errors. Hence it is important to optimize your queries for minimum impact on the database’s performance. 1. Define Business Requirements before Beginning In a previous article, we covered best practices to define business requirements for BI . Those practices should be applied when optimizing SQL queries , including: Identifying relevant stakeholders. Make sure all involved parties are in the discussion of developing your query. When querying production databases, make sure the DBA team is included. Focusing on business outcomes. Be sure the query has a definite and
ASP.NET || Javascript || Dataobject || Code Solutions Free Open Source code for Developers