Skip to main content

Posts

Showing posts from June, 2019

8 Ways to Fine-tune your SQL Queries

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