Forum Discussion
anoopdba
Apr 28, 2023Copper Contributor
Cardinality Estimator understading
I have a query that i am running from the query analyser, there are no trace flags enabled in it. When do properties of the select in the query plan I see following My database is at compatibi...
anoopdba
May 02, 2023Copper Contributor
LainRobertson Thanks for your help. I have gone through the article.
The query i am looking at is performing poorly and i am not sure why it is using an old cardinality estimator even though my database is at latest CE.
LainRobertson
May 02, 2023Silver Contributor
The article outlines multiple reasons in the second bullet point list near the top of the article.
Cheers,
Lain