[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