[dba-SQLServer] Unique indexes vs. constraints

Mark Whittinghill mwhittinghill at symphonyinfo.com
Mon Mar 8 09:45:40 CST 2004


What's the value of using a unique constraint vs. a unique index?  Is it
that you would use an index if you also wanted to sort or search on that
field, and a constraint if you just wanted to enforce uniqueness without the
overhead of an index?  Or is there more to it than that?


Mark Whittinghill
Symphony Information Services
763-391-7400
mwhittinghill at symphonyinfo.com





More information about the dba-SQLServer mailing list