>When creating a unique index and FK constraint on two columns, does the order of columns matter?
>
>For example, I want to have unique index on SITE_NO (Int) and CATEGORY (Char(20) and a FK Constraint on these two fields. Would [SITE_NO],[CATEGORY] create different "results" from [CATEGORY],[SITE_NO]?
>
>TIA
Yes, order of columns matter in the index. Select most selective column first.
If it's not broken, fix it until it is.
My Blog