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