İptal Edildi

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.

Beceriler: SQL, Veri Tabanı Yönetimi, Microsoft SQL Server

Daha fazlasını gör: 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

İşveren Hakkında:
( 7 değerlendirme ) Lake in the Hills, United States

Proje NO: #21310793

Bu iş için 91 freelancer ortalamada $34/saat teklif veriyor

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 / saat
(235 Değerlendirme)
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 / saat
(86 Değerlendirme)
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 Daha Fazla

$50 USD / saat
(172 Değerlendirme)
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 Daha Fazla

$35 USD / saat
(49 Değerlendirme)
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 Daha Fazla

$30 USD / saat
(168 Değerlendirme)
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 Daha Fazla

$40 USD / saat
(19 Değerlendirme)
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 / saat
(25 Değerlendirme)
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 Daha Fazla

$35 USD / saat
(9 Değerlendirme)
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 / saat
(10 Değerlendirme)
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 Daha Fazla

$25 USD / saat
(9 Değerlendirme)
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 Daha Fazla

$25 USD / saat
(30 Değerlendirme)
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 Daha Fazla

$27 USD / saat
(3 Değerlendirme)
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 Daha Fazla

$25 USD / saat
(6 Değerlendirme)
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 Daha Fazla

$35 USD / saat
(3 Değerlendirme)
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 / saat
(17 Değerlendirme)
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 Daha Fazla

$25 USD / saat
(16 Değerlendirme)
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 / saat
(10 Değerlendirme)
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 Daha Fazla

$40 USD / saat
(12 Değerlendirme)
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 / saat
(23 Değerlendirme)
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 Daha Fazla

$50 USD / saat
(1 Yorum)
4.2