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 |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2009-09-22 : 13:42:35
|
| Guys,Is there anyway from system objects I can find all the columns which have more than one index on it with different names?Any suggestions/inputs would be helpful.Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-22 : 15:50:47
|
| You should be able to. Try querying sys.indexes and sys.index_columns.Make sure to check the position of the column in the index, an index on Col1 is not redundant with one on Col2, Col1--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Multiple Indexes on the same column