Dibatalkan

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.

Kemahiran: SQL, Pentadbiran Pangkalan Data, Pelayan Microsoft SQL

Lihat lagi: 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

Tentang Majikan:
( 7 ulasan ) Lake in the Hills, United States

ID Projek: #21310793

91 pekerja bebas membida secara purata $34/jam untuk pekerjaan ini

sumon355

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

$30 USD / jam
(235 Ulasan)
7.5
dotnetsqlCoder

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

$35 USD / jam
(86 Ulasan)
7.2
truongnguyen86

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 Lagi

$50 USD / jam
(172 Ulasan)
6.9
feninsoftech

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 Lagi

$35 USD / jam
(49 Ulasan)
6.6
TakeReal

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 Lagi

$30 USD / jam
(168 Ulasan)
5.8
SergioAlfaroV

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 Lagi

$40 USD / jam
(19 Ulasan)
5.6
Tahir001

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 / jam
(25 Ulasan)
5.0
FerriSoft1

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 Lagi

$35 USD / jam
(9 Ulasan)
5.0
IMExpertEngineer

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 / jam
(10 Ulasan)
5.0
rayyankabir

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 Lagi

$25 USD / jam
(9 Ulasan)
4.5
AliSafder

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 Lagi

$25 USD / jam
(30 Ulasan)
4.6
raindropsin

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 Lagi

$27 USD / jam
(3 Ulasan)
4.6
yuzhao4989

Hi, sir. I mastered sub query in DB. As an experienced developer, I am sure that I can handle your project perfectly. Let me know If you have any time to discuss more details with me. Looking forward to hearing from yo Lagi

$25 USD / jam
(6 Ulasan)
4.4
idragon712

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 Lagi

$35 USD / jam
(3 Ulasan)
4.1
sreenivas2903

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

$50 USD / jam
(17 Ulasan)
4.3
digidreamstech

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 Lagi

$25 USD / jam
(16 Ulasan)
4.9
xutao650

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 / jam
(10 Ulasan)
4.0
jayantavkumar

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 Lagi

$40 USD / jam
(12 Ulasan)
4.0
bhupen2606

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 / jam
(23 Ulasan)
4.2
bogahapitiya

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 Lagi

$50 USD / jam
(1 Ulasan)
4.2