Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
orenh112
Starting Member
2 Posts |
 Posted - 2009-07-13 : 14:47:28
|
| I have a stored procedure in sql 2005 that is on a table with PKey column of type uniqeidcolumn of type uniqueID (Not uniqe)3 columns nvarchar 2 columns of bitmy sp is updating values according to the pkeyreturns result set based on the pkeyreturns result set base on the seconed colum (doing count and summing some values)what indexes should i use on that table? OF WAHT TYPE?thanks and sorry for the stupid questioms |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-13 : 15:18:51
|
| make sure the PK is clustered, put nonclustered on 2nd columnno other indexes based on info in your post |
 |
|
|
|
|
|
query index question