Need help optimizing long running SQL query

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.

Compétences : SQL, Administration de Bases de données, Serveur SQL Microsoft

en voir plus : sql query performance tuning tips, query optimization in sql server with example, sql query performance analysis, how to find slow running query in sql server, how to check query performance in sql server, sql server query optimization tips, how to identify slow running queries in sql server 2008, sql query optimization tool

Concernant l'employeur :
( 7 commentaires ) Lake in the Hills, United States

Nº du projet : #21310793

89 freelance font une offre moyenne de $34/heure pour ce travail


Hello, As an expert in SQL, i am very much interested to optimize the query. Is it for MySQL or MSSQL? Thanks

$30 USD / heure
(239 Commentaires)

Hello there Did you try column store indexes ? Do you need to return the whole 71 million or a subset ?

$35 USD / heure
(86 Commentaires)

Hello there, i'm expert on MSSQL especially with tuning, i've worked with table more than 1 billions record. About your query, first we need to investigate we have proper index or not. Next we need to see the query to Plus

$50 USD / heure
(181 Commentaires)

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 j Plus

$35 USD / heure
(51 Commentaires)

Hello, My name is Sergey. I am Freelancer from [login to view URL], Russia. I can help you to speed up slow SQL query. I need access to your database to start my work. This is list of similar projects, successfully c Plus

$30 USD / heure
(168 Commentaires)

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 Plus

$40 USD / heure
(19 Commentaires)

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 / heure
(25 Commentaires)

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 / heure
(10 Commentaires)

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 Plus

$25 USD / heure
(11 Commentaires)

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 Plus

$35 USD / heure
(9 Commentaires)

Hi Did you try to add indexes on the joint columns? I can help to check it. I am a software engineer with 8 years' experience of .net developing. Please contact me for further discussion.

$25 USD / heure
(11 Commentaires)

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 Plus

$40 USD / heure
(15 Commentaires)

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 Offic Plus

$25 USD / heure
(10 Commentaires)

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 Plus

$25 USD / heure
(21 Commentaires)

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 Wher Plus

$27 USD / heure
(3 Commentaires)

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 wor Plus

$25 USD / heure
(31 Commentaires)

Hi. I am expertise in sql queries and also optimization if u are willing to work ping me for more information

$50 USD / heure
(17 Commentaires)

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 Plus

$35 USD / heure
(3 Commentaires)

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 / heure
(23 Commentaires)

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 contac Plus

$50 USD / heure
(1 Évaluation)