Apr 28 2023 08:40 AM
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 compatibility lever 150, so why i am seeing this? Is it normal ?
Apr 30 2023 05:06 AM
The cardinality estimation version can vary, and a lower value doesn't automatically imply something is wrong.
Read the following article thoroughly as it covers:
Cheers,
Lain
May 02 2023 12:47 AM
@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.
May 02 2023 03:27 PM
The article outlines multiple reasons in the second bullet point list near the top of the article.
Cheers,
Lain