Reputation: 2380
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
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
execution plan, pasted as requested
Upvotes: 0
Views: 183