Hello Colin.

try and have a look applying a check constraint and a FK on those 23
million rows.
There is a very old 'bug' fea out there where it states that applying
a foreighn key does not go paralel even with pdq set.
( the result of course is adding a FK is/was slow)

So set pdqpriority 100 and have a look how many threads you gonna get.
May be this is fixed in V10


Superboer.


On 2 feb, 12:35, "Colin Dawson" wrote:
> I'm canvassing opinion on this.
>
> A table with millions of rows has a check constraint with 23 values in it. I
> have suggested that a reference table is used instead.
>
> Is it better for performance to use a Check Constraint and occasionally have
> maintenance if a new value is required than have easier management of the
> data and a FK index.
>
> My preference is to use a reference table.
>
> Regards
>
> Colin
>
> There are 10 types of people in the world, those that understand binary and
> those that don't
>
> _________________________________________________________________
> Get Hotmail, News, Sport and Entertainment from MSN on your mobile. http://www.msn.txt4content.com/