Forum Discussion
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...
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.
The article outlines multiple reasons in the second bullet point list near the top of the article.
Cheers,
Lain