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...

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

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

İşveren Hakkında:
( 57 değerlendirme ) United States

Proje NO: #15370932



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. " Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(1070 Değerlendirme)

Bu iş için 2 freelancer ortalamada $38 teklif veriyor


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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)