I have got a ms SQL relation database. There is one complex search query with around 30 joins and self joins. It has around 21 where clauses. I am looking for ways to speed up this query. You can add more index to database or restructure this query.
I will provide you with copy of database.
I can see the query only has a where clause filtering on a name (company name I think). Leaving the search fairly open ended like this can sometimes cause longer response times, compared to filtering by a specific client, sample number, job, date range etc. Also this is a free text field (which requires a number of joins) which probably contributes to the longer time.
51 freelancer đang chào giá trung bình $186 cho công việc này
I have 20 years in Database Developing, administration, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA, VB6, Vb.net, C#, SQL, SQL/PL SQL, and MS SQL Server