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 |
|
FruitBatInShades
Yak Posting Veteran
51 Posts |
 Posted - 2011-03-04 : 06:49:36
|
| I have a table that is used purely for associationTagId (int)ObjectTypeId (int)ObjectId (int)What is the best way to index this table (if at all). There are not many writes but frequent lookups.Many Thanks |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2011-03-04 : 08:39:15
|
| you index the columns that are used in "join" clauses and "where" conditions.sometimes all you needs is sinle columns indexed, sometimes you need multi-columns in the indices.show us some sample data and sample queries for more detailed advice. |
 |
|
|
|
|
|
Indexing a lookup table?