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 |
|
Scal
Starting Member
24 Posts |
 Posted - 2011-04-22 : 11:05:33
|
| Hi;I didn't find any post with adives, best practices, etc on Indexes/Keys and Relationships. I'm kinda lost with MSDN articles and still can't figure out on which columns I should put Indexes/Keys and or Relationships.If I remember correctly, it's been years I haven't worked with DBs, it's good to use indexes on columns that are part of "WHERE" clause; correct?What is best for relational tables that have joins? Indexes or Relationships?If someone has a good resource(s) (blog, forum post here, etc.) on this topic, could you be kind to share?Thanks! |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
Scal
Starting Member
24 Posts |
Posted - 2011-04-26 : 07:26:16
|
| Thanks GilaMonster;I'll look into those. |
 |
|
|
|
|
|
Indexes/Keys and Relationships for performance?