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 |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2008-07-30 : 02:17:43
|
| sql server 2005.Can you set an index on cols that have been aggregated as a primary key?i.e. can you group them as an aggregate index just like you would when highlighting two or more when you set a primary key?If so, How? as when I right click on the table in design mode I seem to be only able to set them one at a time. |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2008-07-30 : 02:47:54
|
| Found it and done it thanks.CREATE NONCLUSTERED INDEX IX_indexname ON dbo.tablename (col1,col2,col3);GO |
 |
|
|
|
|
|
Indexing on multiple cols?