Unique Key Constraint, Querable index?

[SteveDingle]

Heya All,

All my tables have surrogate PK's which means that all my tables also have alternate keys which I am currently enforcing using Unique Key Constraint as opposed to a Unique Index. My question is, does the constraint help in querying against the table? If not should I also have a index on the AK expression or should I just be using a unique index as opposed to a constraint

This is important since often the AK's are used to retrieve a record as opposed to the PK

Thanks!

 

[r937]

as far as i know a unique constraint is implemented as a unique index, so you're okay

r937.com | rudy.ca