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...
Also, ensure that the indexes are the same across both environments and check statistics on the production instance. They may be stale and need to be updated.
