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 |
|
steppinthrax
Starting Member
27 Posts |
 Posted - 2011-07-11 : 09:10:56
|
| I'm curious what are the guidlines for indexing columns. I want to apply indexes on Foreign Key Columns within a database. I need to make a determination on canidate columns to index?? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-07-11 : 14:16:28
|
| FWIW: I use the rule that you need to have a good reason NOT to have an index on your foreign key columns.=======================================I have never met a man so ignorant that I couldn't learn something from him. -Galileo Galilei, physicist and astronomer (1564-1642) |
 |
|
|
|
|
|
Indexing Foreign Keys