Find Jobs
Hire Freelancers

optimize SQL querry to fetch records faster. i have sql querry will share on chat . its complex with joins im looking to optimize it using indexes or anyother way. reply me for details

$10-30 USD

Closed
Posted about 5 years ago

$10-30 USD

Paid on delivery
I need you to develop some software for me. I would like this software to be developed using SQL.
Project ID: 18659607

About the project

37 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
37 freelancers are bidding on average $29 USD for this job
User Avatar
Hello, As an expert in SQL, i am very much interested to optimize your query. Are you using ms sql server? Looking forward to have a positive response from you. Thanks
$29 USD in 1 day
5.0 (217 reviews)
7.5
7.5
User Avatar
Hi I am a database expert with 12 years experience in handling MS SQL and MySQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. Can you please share the query so that I could take a look. Do you have a lot of records in the tables/resultset? Is it ok to rewrite the query as a stored procedure if needed? Will you be able to give ateam viewer access to your server totry out the query, or give me a database backup to try it on my server? Thanks Roni
$40 USD in 1 day
5.0 (76 reviews)
6.4
6.4
User Avatar
There are many factors when you are facing performance issue on your query. I am listing down some of the tips which needs to take into consideration before designing any of the query: 1. The design of the query should be based on the technology. like Oracle/MySQL reads data from right to left where SQL use left to right in where condition. So where condition is playing very crucial role to achieve better performance. 2. Your column sequence in your select statement should be in the same order which you have in your indexes. 3. Most filtered condition should come first in the query. 4. Base table should be used first in your from clause and then rest based on the use of the columns in select statement. 5. Query should be splitted into small pieces if indexes are not calling and we are not allowed to alter our indexes. 6. Estimated and Actual plan of the query will help to tune the index. 7. Your index de-fragmentation should be scheduled on daily basis or as per your need. At least you have to do this defragmentation when there are major update and delete happens in your database. 8. You can create Indexed View if you are using OLAP database. There are many more things which we have to keep in consideration while designing of the query. My Technical expertize. I am a database architect on Oracle, SQL server and MySQL and having 13+ years of experience in IT industry. Let me know if you want to discuss more about your requirement.
$25 USD in 1 day
5.0 (27 reviews)
4.9
4.9
User Avatar
hi I am expertise in sql qery and fine tuning . if fyou really interested ping me for more info . i would like to work and finish. but i as per the quality of work my bid amount also bit high
$45 USD in 1 day
4.9 (15 reviews)
4.4
4.4
User Avatar
I have big experience as Senior Database Developer/DBA. I Know well SQL and query optimization. Fast and good result.
$20 USD in 1 day
5.0 (4 reviews)
3.4
3.4
User Avatar
I am data engineer with 4+ years of industry experience. I have been working on data analytics solutions for complex business systems with scale, HA etc. Can do this work for you. Relevant Skills and Experience Expertise in 1. Sql optimization with best practices of target engine 2. Sql optimization using predicate algebra and calculs Looking forward to hearing from you
$50 USD in 1 day
5.0 (2 reviews)
2.9
2.9
User Avatar
I am good at Sql query optimization.I need to look at the execution plan of the query after that can look for the solution with indexing or rewriting the query if needed
$25 USD in 1 day
5.0 (4 reviews)
3.0
3.0
User Avatar
I am full time freelancer working from home. Having 13 + years experience in .NET, SQL SERVER and willing to start the work immediately.
$35 USD in 1 day
5.0 (2 reviews)
2.4
2.4
User Avatar
Hi. *********sql expert************ I am a full stack developer and have been working for over 5 years on freelancer.com. I have read your description in detail and have interests in your project. I have some experiences that have ever done what is similar to your project. As a solution, I have a good idea to build your project perfectly I would like to have a discussion with chat to get more about your project. Thanks.
$30 USD in 1 day
4.6 (1 review)
0.8
0.8
User Avatar
HI, Hope you are doing good. As 7+ years experienced SQL server developer with good knowledge in performance tuning, I am confident that I can optimize your query utilizing my extensive experience within SQL. I look forward to working with you! Thank You.
$15 USD in 1 day
5.0 (1 review)
0.4
0.4
User Avatar
Hello, I would like to know if you are using a mysql or oracle? I am willing to help you figure out what would be the constraint of your script. I have been working with different analytics using dbms with very slow query.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Have 3 years of SQL developing experience along with base sas certification.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I would like to optimize your query with my expertise in SQL development. I would help you in understanding the query execution plan and figure out areas of improvement in updating indexes. Thanks and regards, Thangapandy
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 9 years of experience as a database developer, and i am a database consultant. Please share your database and query. I will fine tune it to get maximum speed.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, can I read details ? I'm working with sql more 15 years and I can try help you. I'm database developer
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have an experiences with Oracle APEX, it able to generate form and report based on a query. As it built in Oracle database, you can do some query optimization. I assume your query based on several tables. Please send me your query and I will create optimized query for you.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sender, Thanks for the requirement. I have profound experience in sql , pl/sql , Oracle forms and reports 11g and work on various projects on same technologies. I would like to complete your requirement within given timelines. Thanks.
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Bad Query Performance is cause of multiple reasons. I can solve the query performance issue with multiple approach. Also I will recomend best approach for query writing. Mind SQL consultant
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I will optimize your query. index your table it's easy for me, I have 2+ year experience in SQL database
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi.. i am a computer engineer and I can try to write the queries as per your requirements
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Seattle, United States
0.0
0
Member since Feb 5, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.