Find Jobs
Hire Freelancers

Need help optimizing long running SQL query

$25-50 USD / hour

Preklicano
Objavljeno pred več kot 4 leti

$25-50 USD / hour

The query is a straightforward inner join with a table that contains 71000000 records. It currently takes anywhere between 1 and 3 minutes to run.
ID projekta: 21310793

Več o projektu

73 ponudb
Projekt na daljavo
Aktivno pred 5 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
73 freelancerjev je oddalo ponudbo s povprečno vrednostjo $33 USD/uro za to delo
Avatar uporabnika
Hello, As an expert in SQL, i am very much interested to optimize the query. Is it for MySQL or MSSQL? Thanks
$30 USD v 40 dneh
5,0 (286 ocen)
7,8
7,8
Avatar uporabnika
Hello there Did you try column store indexes ? Do you need to return the whole 71 million or a subset ?
$35 USD v 40 dneh
5,0 (90 ocen)
7,7
7,7
Avatar uporabnika
Hi, I have 11 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenance jobs, Optimizing etc. I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have delivered highly successful projects in ASP.NET, C#/VB.NET Win-Forms, EF with complex logic in SQL Server Stored Procedures. Microsoft Certified Technology Specialist in SQL Server. Thanks
$35 USD v 40 dneh
4,9 (52 ocen)
6,8
6,8
Avatar uporabnika
Hi! can you share through the CHAT the SQL QUERY, and the DB Schema (of course without the data), or at least the Schema of the Tables involved in the QUERY Note: The schema have to be generated straight from the SQL Server Managment Studio, to have all the attributes like Indexing etc Thanks! Felice
$35 USD v 40 dneh
5,0 (11 ocen)
6,2
6,2
Avatar uporabnika
Hi There, Have you checked its execution plan of the query? I believe in good communication and usually, reply within minutes of ping from you. I'll wait for your ping on chat to discuss more on the project. I have more than 10 years of experience in developing .NET solutions with building small and big distributed high-load applications. I am a technologist at heart with the right intent and skillset to deliver high-quality and stable projects in web application and hybrid mobile application using new technologies. Regards, Shobhit Pundir
$25 USD v 40 dneh
5,0 (21 ocen)
5,5
5,5
Avatar uporabnika
Hello! I am a Computer Engineer, with a Master of Business Administration and an MCSA SQL Server 2014, with 12 years of experience using SQL, queries, database design & construction, database management, tuning, query optimization, data warehousing, and related projects and tasks. I am a near-native English speaker, currently available, and results-oriented. I can help you optimizing your T-SQL query, that is something that I've worked on before, with successful results. I am located in the American Central Time Zone, which means we share similar office hours. We can discuss details over chat if you like. Thanks!
$40 USD v 40 dneh
4,9 (23 ocen)
5,7
5,7
Avatar uporabnika
Hello, how are you. Your query should not take that much time if proper indexes are applied. Can you please show me you query. Thanks
$40 USD v 40 dneh
5,0 (25 ocen)
5,0
5,0
Avatar uporabnika
Hi, My Name is Ali and I can work on it with immediate availability. I can implement non clustered indexes. You can see my portfolio where there is chain of similar projects. Let's have quick discussion so I can work on it.
$25 USD v 10 dneh
5,0 (36 ocen)
4,9
4,9
Avatar uporabnika
Hi, I'm expert in sql server and have performed lot of query optimization . I can work on this project , please message me to discuss further. thanks
$38 USD v 40 dneh
5,0 (10 ocen)
5,0
5,0
Avatar uporabnika
Proposal - I can optimize your query and will try to reduce response time by 50%. You can expect any thing on SQL Server. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL -- Proficiency (P4) BI - Microsoft MSBI and Informatica ETL -- Proficiency (P4) Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... -- Proficiency (P3) Cloud - Azure (Paas and IaaS) -- -- Proficiency (P1) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$40 USD v 40 dneh
5,0 (31 ocen)
5,0
5,0
Avatar uporabnika
Hi there, Greetings! I am an experienced database developer. I have been developing custom database solutions for the past 12 years. I have excellent depth over MS Access, VBA, ADO, SQL, MySQL, Excel, and other Office applications. Let's get on a chat to discuss your requirements in detail. Thank you, Rayyan
$25 USD v 40 dneh
5,0 (11 ocen)
4,7
4,7
Avatar uporabnika
Hello, How are you? I am a full-stack developer having good SQL skill and am interested in working in your project. I can perfectly work for you. Let's discuss fully the project details together and I am looking forward to working with. Regards!
$25 USD v 40 dneh
5,0 (2 ocen)
4,6
4,6
Avatar uporabnika
Hello, I have gone through the project detail, I am having required PL/SQL skills as described by you in the requirements to optimize SQL queries. I am ready to start on this project. We can discuss further in private message. Thanks.
$25 USD v 40 dneh
4,3 (21 ocen)
5,5
5,5
Avatar uporabnika
Hi. I am very interested in your project. i have rich experience on it. I think this project is very suitable for me and i am sure i can give you good result . If you award me for your project, you will get good result . please call me.
$38 USD v 40 dneh
5,0 (2 ocen)
4,4
4,4
Avatar uporabnika
Dear Client. I have some solution for it. The message queue or elastic search can be used for it. Could you tell me about your system? Was it build with php? I 'd like to learn more about it. Please feel free to contact me. Best Regards.
$50 USD v 40 dneh
5,0 (1 ocena)
4,2
4,2
Avatar uporabnika
Hi, i have very good experience with sql query optimization. Please let me the table/index details and query criteria. Based on these details i should be able to quickly optimize your query.
$35 USD v 40 dneh
5,0 (25 ocen)
4,3
4,3
Avatar uporabnika
Hi. I am expertise in sql queries and also optimization if u are willing to work ping me for more information
$50 USD v 3 dneh
4,9 (20 ocen)
4,5
4,5
Avatar uporabnika
Hello! The SQL injections are not new for me. Even I have 10+ years of continuous experience in this field so I will take care of the SQL injections and the database. I wanted to see existing tables and database Where I have to Please hit me over the chatbox with "hi" message. Thanks, Vivek
$27 USD v 40 dneh
5,0 (3 ocen)
4,6
4,6
Avatar uporabnika
HI team, Would love to tune this query and check it out. Dont pay us till you are not satisfy with our solution of tuning the query. We are the team of database development who can work with you day and night and help u in resolving the issues.
$40 USD v 40 dneh
5,0 (19 ocen)
4,4
4,4
Avatar uporabnika
Hello, I am a senior web developer with rich experiences about PHP, SQL query. Please contact me and then let's discuss in detail your requirement so that you can get the satisfying results. If you hire me, I will do the best with high quality according to your request. Best Regards.
$35 USD v 40 dneh
5,0 (3 ocen)
4,1
4,1

O stranki

Zastava UNITED STATES
Lake in the Hills, United States
5,0
10
Plačilna metoda je verificirana
Član(ica) od jul. 10, 2017

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.