Oracle SQL Query rewriting to run it fast

Hi, Greetings! ✅checked your project details: Oracle SQL Query rewriting to run it fast ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast

I will be glad to refactor your query. There are a lot of issues that makes negative impact on execution performance and should be solved. I can not guaranty that execution time will be below 30 seconds but I definitely will resolve all bottlenecks which decrease an execution performance.

Dear sir. Your query have multi problem can improve. It have so many subquery overlap. We need see explain plan to understand the data. Please feel free send a message to me for reciving some advice. I have worked as database developer for 5 years. I familiar with database larger than 100TB. I optimze many queries like your. I will analyze and optimize for you to archive the goal with extra fast service. Have a great day

Hello, I am a veteran (25 + years) Oracle database developer. Worked in Oracle from the late 1990s (v6 thru 18c). Solid SQL and PL/SQL skills. That said, I need a copy of your schema + data. Otherwise, this will be a theoretical job and will not yield proper results. Please also mention the Oracle server version which you are using. I look forward to hearing from you. Best Regards Kashi

Hello To improve your query I should now some details about tables and relationships between them, what indexes are built, what is the data amount and distribution, etc. Can you give me structure of tables , statistics and Explain plan of this query?(or sharing your screen would be the perfect variant ) I am an Oracle database developer with more than 7 years experience working and I've done a lot of query optimization work. Looking forward to discuss further details via chat.

Hi - I am a certified database developer with experience in both SQL and NOSQL databases. I have optimized a number of SQL queries in the past and I have a good hand over this job. I will be able to rewrite your query which will help in faster execution if you give me the opportunity. Thank you.

Hey There, I saw your query. I believeto speed up the query you have added "parallel" hints but it's not always helpful. There are so many other techniques we can implement. If you allows me then I'm glad to help you. I can assure you that we can easily complete the query within 30 seconds. I have tuned literally 500+ queries with 100+ DBs. I'm an Oracle certified DBA. Please feel free to go through my profile. Awiting for your positive response. Warm Regards, Amol V. PAlav

Hi , I am an SQL query tuning expert , I have fixed lot of SQL query for better performance , I just need few hours time to fix this with DB connection and we can have it as a live session while I connect and fix it for you , I can help you on this , please feel free to contact I am a trustworthy and friendly Thanks Ram

I am core SQL Server Production DBA with 10+ years of Experience and Microsoft SQL Server 2012/2104 MCSA Certified and Oracle database management

Dear, I am Oracle Certified DBA with 8 year of experience in database performance Tuning , SQL Tuning and Database Administration. I have tuned many SQL by tuning the their joins , Indexes, profiling , stats collection and other methods. You can assign this to me. Thanks Pankaj

Don't got it.........................................................................................

Hi Team, Hope you are doing good. Please provide your system , i can work on this.i have many experience in tuning. I am having around 11 years of IT experience which Includes mainly in the area of Database development,Design,Maintenance,Management along with worked on many data Warehouse projects. Mainly worked on Oracle, MYSQL,SQL,PLSQL,SQL SERVER, HANA DB servers as well as MS ACCESS,TIDAL scheduler,VBA,VB.NET,C#,PHP,VB and crystal reports. lets meetup and start working on . Thanks, Wasim

Hi I have gone through your query, It needs some changes. I can help with this withing less amount of time. Regards, Mayank, 7753964555

Hi, I am a specialist in SQL server performance optimization . Have handled multiple projects Relevant Skills and Experience Having 10+ year of experience in Sql

I have more than 13 years of IT experience with various database technologies. Working Knowledge of MS-Sql,postgres,Oracle,mysql Databases. Expertise in developing skill , proficient in PL-SQL writing stored procedures, triggers and functions. Worked in build complex query. Built ERD Diagram Database tuning experience. Good written and client interaction skills at all management level. Energetic self-starter and can learn new technology in short time. Tuning query performance and recommending better way to optimize SQL queries and pl-pgsql/T SQL programs Migration experience from Oracle to Postgres, Postgres to MS-SQL. Performed migration till 5 TB of Databases. Having Developing/DBA experience of postgres database size more than 10 TB. less

13 of extensive experience in Data development and analysis. quoting two days as one day is required to understand the data structure and then another day to tune the joins according to the requirements

Hi, I am very strong in Relational database and my query skills are top notch. I would have bid for less, but looking at your query and number of tables. it will take a while to analyze, but i am sure i would be able to fine tune your query to reduce time

Hi, nice to greet you! I am a financial services CIO in México. I am an expert in data bases, specially in Oracle! I love improve querys, I am the best doing it. I have improve time of complex querys, similar your query. I had analyzed your code, and I have the solution. I can reduce the time to seconds. Can you give me an opportunity, please? Thanks a lot. Jose Landin

I have configured similar queries multiple times and I should be able to help you out on this. Let me know if you like to discuss further on this and get it resolved.

Having more than 15 yr of experience in oracle database and spring mvc .have also vast knowledge in perfomance tuning in SQL level and DB level.