Ron Johnson <ron.l.johnson@cox.net> writes: > Based on LENGTH(offending_column), none of the values are more than 144 > bytes in this 44.2M row table. Even though VARCHAR is, by definition, > variable length, are there any internal design issues which would make > things more efficient if it were dropped to, for example, VARCHAR(256)?
No.
So the declarative column length has no bearing on memory grants during plan generation/execution?