Tag Info

New answers tagged


Is there an explanation for the cardinality estimate of 1.0003 for SQL 2014 while SQL 2012 estimates 31,622 rows? I think @Zane's answer covers this part pretty well. Is there a good workaround? You could try creating a Non-Persisted Computed Column for LEN(cust_nbr) and then create a Non-Clustered Index on that Computed Column. That should only ...


Okay so this is what I've been able to find with some digging. For the legacy CE, I see the estimate is for 3.16228 % of the rows – and that is a “magic number” heuristic used for column = literal predicates (there are other heuristics based on predicate construction – but the LEN wrapped around the column for the legacy CE results matches this ...

Top 50 recent answers are included