SQL Query Optimization

Hi SQLers!

I have a very complex SQL query for one of my programs, and I am trying to see if there is anyone who can optimize the speed. Currently, the query takes 3 minutes, and the total execution time I have to complete my processing is 5 minutes (the overall process is on a 5 minute cron job, so the SQL query takes the majority of the time).

The query is very long so I have posted it in a GIST here: [url removed, login to view]

You'll see there are a lot of "OR symbol = 'mysymbol'" WHERE clauses, and perhaps that might be the cause. I'm not sure, thats why I'm here.

I own the server, and the DB, so I'm happy to provide access to the winning bidder.

I am using Azure SQL if it matters...

Skills: Azure, Microsoft Access, MySQL, PostgreSQL, SQL

See more: sql optimization techniques, sql query optimization tips, query optimization techniques in sql server 2008 with example, sql query performance tuning tips, how to optimize sql query in oracle, sql query optimization tool, sql query optimization interview questions, how to optimize mysql query, sql query optimization, approach sql query optimization data mining environment, query optimization drupal, sqlite query optimization, query optimization oscommerce, project report query optimization, oscommerce database query optimization, database query optimization, freelance mysql query optimization, query optimization website, sql server running totals update query, sql server parent child tree query

About the Employer:
( 57 reviews ) United States

Project ID: #15370932

Awarded to:


Hello, My name is Sergey. I am Freelancer from [login to view URL], Russia. I have checked your SQL. I can help you to speed up it. I need access to your Azure database to run my tests. Relevant Skills and Experience 1. " More

$50 USD in 1 day
(1070 Reviews)

2 freelancers are bidding on average $38 for this job


HELLO This is the very first time I've ever made a bid on this platform. so I haven't any rewiew,therefore I 'll do my best for ur project. Hire me,and then u'll get more than u think. Relevant Skills and Experience A More

$25 USD in 1 day
(0 Reviews)