Forum Discussion
Solved
SQL Ssrver Query Optimisation
Hi everyone, I am currently building a SQL report, but i need somebody to help me optimize my query. The query is working fine and pulling data, only if a selected a specific product (one or two),...
- It sounds like sql execute timeout, check the report log to confirm. Or put this SQL in SSMS, replace params to certain values. If problem was still there: 1. Build indexes for large tables. 2. Remove joined table and conditions one by one to indicate the range probably cause the issue.
This worked : 1. Build indexes for large tables.
Thanks rodgerkong​