2 days
Query Optimization and/or Query Rewrite
About this ad
Query Optimization and/or Query RewriteWhat you get with this Offer
Title: [5-day-delivery] Query Optimization and/or Query Rewrite
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
#Analysis
#ArticleRewriting
#SearchEngineOptimization(SEO)
#SoftwareConfiguration
#StructuredQueryLanguage(SQL)
About the seller
Reviews on the ad
-
Frank O. 5 days ago
Excellent job and will be back again
-
DPC Consultants Ltd 29 days ago
Brilliant work again. Thank you!
-
David A. 8 days ago
Excellent work. I'm very pleased
-
Erwan N. 6 days ago
Another perfect job :-)
-
Levity Digital 4 days ago
Great work once again!
-
Richard W. 19 days ago
Fantastic work
-
Kristian P. 6 days ago
As usual, excellent. Thanks
-
Dorothea F. 4 days ago
very helpful, patient and delivered the project exactly how I wanted it.
-
Jonathan C. 29 days ago
Fantastic work as always. With a rapid turn around liter
-
Laurent J. 15 days ago
excellent work