Need help optimizing long running SQL query

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

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

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

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

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

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!

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

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.

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

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;

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

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!

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.

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.

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.

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.

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

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

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.

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.