roncansan
roncansan

Reputation: 2380

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

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

Upvotes: 0

Views: 183

Answers (0)

Related Questions