Using WITH (NOEXPAND) to Get Parallelism with Scalar UDFs in Indexed Views
7 Comments
Scalar functions are the butt of everybody’s jokes: their costs are wrong, their STATS IO results are wrong, they stop parallelism when they’re in check constraints, their stats are wrong in 2017 CU3, they stop parallelism in index rebuilds and CHECKDB, I could go on and on. Recently, we ran across yet another scenario where…
Read More