Re: Check Constraint or Foreign Key Constraint

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" <cjd_1...@hotmail.com> 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/