On Wed, 23 Apr 2008 07:17:30 -0700 (PDT), Bill E. wrote:
(snip)
>I would think that the optimizer would first use the index on
>QuestionID and this would eliminate the "baggage" of having to sort
>through the responses to long questions in the AnswerText column but
>perhaps this isn't the case.
Hi Bill,
I'd think so too.
The only way to be sure is to test it. Preferably on the same hardware
and with the same data that your production system willl use.
Frankly though, I see no reason to choose the extra column. I do wonder
however if the column for the answer really has to be varchar(MAX). Are
you actually expecting ever to get answers over 8,000 characters in
length? You are aware that an average Word do***ent has about 2,000
character per (full) page, are you?
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
|
