Given the same textual data, is an inner join to a VARCHAR(MAX) any less efficient than the same join to i.e., a VARCHAR(128)? No keys or indexed fields are involved.
From some testing - looks like yes. even using a varchar(8000) vs varchar(max) shows some rather marked differences.
---------------------------------------------------------------------------------- Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply