Re: Check Constraint or Foreign Key Constraint
try and have a look applying a check constraint and a FK on those 23
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
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.
> 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/