Forum Discussion
Performance issue in Production box
Hi Folks, I have one query which will give only 192 records from database tables. In that query multiple SQL views are used. When I am executing that query in Production it is taking 3 mins b...
As mentioned, likely to be a difference in the datasets (ie. Smaller rowcounts in non prod), stats out of date, possibly hardware differences between the environments.
Start with updating the stats and see if that works. The execution plan should hopefully change to what you're looking for👍🏻