SQL Optimization
- or -
Post a project like this$$
- Posted:
- Proposals: 17
- Remote
- #4153864
- Expired
UK-based Design Specialist | Skilled Multimedia Expert |Photo & Video Editor, Graphic designer, 2D Animator
London
Experienced Full Stack Web and App Developer |Android and IOS App Development| Project Management
London
⭐ TOP RATED ⭐ Graphic Designer| WordPress / WIX |2D Animator| Video Editing |Photoshop Expert
Karachi
42964811078102710748384105364151046046691273209062478814635648997847619833061741876130
Description
Experience Level: Intermediate
I am presently encountering performance issues with a certain SQL query, relying heavily on joins. The complexity of understanding the query also adds to it, taking away precious time and productivity.
My performance measurement indicator is query execution time. The quicker the execution, the better the performance. Therefore, my project involves reconstructing this query to use Common Table Expressions (CTE) instead of joins. I would also need you to create views based on this newly optimized query.
The database management system in use is PostgreSQL. Corresponding experience and knowledge in this system, along with skill in CTE implementation and optimizing SQL queries are pertinent.
Skills and Experience:
- PostgreSQL expertise
- Proficient in SQL and CTE
- Familiar with performance metrics like execution time
- Experience in building SQL views
The goal of this project is to have a more streamlined and efficient SQL query that uses less execution time. Your prime responsibility would be to restructure and simplify the query without disturbing its functionality.
Shawn D.
100% (7)Projects Completed
7
Freelancers worked with
5
Projects awarded
20%
Last project
7 Sep 2023
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies