Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

Evaluate the creation of indexes based on the access patterns

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 unique purpose. Taxing the production database for exploratory or duplicative reports is an unnecessary risk.
  • Framing the discussion for good requirements. Define the function and scope of the report by identifying its intended audience. This will focus the query on the tables with the correct level of detail.
  • Develop good requirements by asking great questions. Those questions typically follow the 5 W’s – Who? What? Where? When? Why?
  • Write very specific requirements and confirm them with stakeholders. The performance of the production database is too critical to have unclear or ambiguous requirements. Make sure the requirements are as specific as possible, and confirm the requirements with all stakeholders before running the query.