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 |
|
sd
Starting Member
6 Posts |
 Posted - 2009-02-27 : 17:02:28
|
| Hi,I am building a database from the design diagram provided to me.In one of the tables its mentioned that there are 3 FK and all are to be indexed.Can anyone suggest me which index (clustered or non clustered) should i use and the sql command for it.Thanks,Sd |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-02-27 : 17:11:38
|
Well first of all, there can only be one clustered index on a given table. Decisions on Primary Key, which column(s) should be the clustered index, and nonclustered indexes, etc. are complex decisions that depends on a lot of factors that you haven't provided. I suggest that since you were given design that you go back to whoever designed it ask them.As to the command syntax, have you looked in Books Online yet? perhaps under "create index"  Be One with the OptimizerTG |
 |
|
|
sd
Starting Member
6 Posts |
Posted - 2009-02-27 : 17:35:32
|
| Thanks for your reply TG :)Actually I would like to know what are the factors to consider before going forward with creating it.Since am new to indexing I didnt know what else i had to provide. |
|
|
|
|
|
|
Foreign key indexing