After changing a column from ntext to varchar(max) a query becomes slightly slower

177 Views Asked by At

After changing a column from ntext to varchar(max) a query becomes slightly slower.

I'm doing a

select * from table_with_ntext

vs

select * from table_with_nvarchar_max

enter image description here

I thought that since the lob logical reads decrease so much (213860 vs 6) vs the gain on logical reads (2572 vs 3384). The query will be faster, even when the CPU Time is faster (812 vs 547), the elapse time is slower (2032 vs 3384).

Note: I run the same comparison several time and always the table_with_ntext was faster by a similar margin.

Can someone explain this behavior?

Thanks

enter image description here

execution plan, pasted as requested

0

There are 0 best solutions below