Posted by Hugo Kornelis on 08/06/05 02:27

On 5 Aug 2005 16:17:51 -0700, csomberg@dwr.com wrote:

>SQL Server 2000 SP4
>
>I was wondering what has the best performance for maintaining
>referential integrity ... triggers, constraints etc .....
>
>Thanks,
>
>Craig

Hi Craig,

Use constraints where you can. Resort to triggers only when you can't
use constraints. Constraints are faster, plus they provide extra
information to the optimzer. And they're less work too :-)

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

[Back to original message]