Forum Discussion
Query Optimizer unable to create execution plan
I have a very strange thing happening on my SQL Server 2019 Enterprise edition. My database is rather small ( 120 Gig ) and is used by a 3rd party application, so something I can't change. The appl...
Hello,
I'll strongly suggest you to make sure that you have the statistics updated. this is extremely important for the sql engine to come up with right execution plans.
Also will be interesting to know if this 3rd party apps relies on Stored procedures or Ad Hoc queries
Regards
Javier
I'll strongly suggest you to make sure that you have the statistics updated. this is extremely important for the sql engine to come up with right execution plans.
Also will be interesting to know if this 3rd party apps relies on Stored procedures or Ad Hoc queries
Regards
Javier