[5-day-delivery] Query Optimization

* 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 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 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