Avatar of curiouswebster
Flag for United States of America

asked on 

When to use a Unique Index? A Clustered Index?

When I have a slow performing query that uses a single field in the where clause, is that a good field on which to create a Unique Index?

Otherwise, what are a few rules of thumb when deciding which field could boost performance by having a Unique Index?

Now, please explain how a Clustered Index fits in? What big problems do they solve?

DatabasesMicrosoft SQL ServerMicrosoft SQL Server 2008* T-SQLSQL

Avatar of undefined
Last Comment

8/22/2022 - Mon