[5-day-delivery] Query Optimization

Metadata

  • Title: [5-day-delivery] Query Optimization
  • Category: 5-day-delivery
  • Tag(s): Query Optimization, SQL Server, MySQL, PostgreSQL, Oracle, Performance
  • Description: You want to optimize SQL queries.

Management

  • Fixed-time: 5 working day(s)
  • Fixed-scope: 1-10 SQL queries
  • Fixed-price: $500

Work Breakdown

  • Create a baseline (execution time, plan, etc)
  • Execution plan analysis
  • Optimization
    • Query rewrite
    • Indexes
    • Schema changes
    • Configuration changes
  • Comparison with baseline
  • Clarification call

Out of Scope

  • Some solutions might require planning for a maintenance window and thus are out-of-scope for this task.

Deliverable(s)

  • Statistics and execution plan of each query
  • Performance comparison (baseline Vs optimized)
  • Recommendations
    • Indexes
    • Schema changes
    • Configuration changes
  • 1st round of unit testing
  • Clarification call (up to 1 hour)

Prerequisite(s)

  • Database server access
  • Data model to understand the database schema
  • Data dictionary to understand the contents of the database