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 |
|
fahad yaseen
Starting Member
8 Posts |
 Posted - 2014-08-04 : 10:09:04
|
| ?? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-04 : 12:21:45
|
| The best option would be not to choose one but to choose both. You should always have a clustered index on a table and then you should add nonclustered indexes as appropriate, based on the queries. As a general rule of thumb, I add indexes to the foreign keys and then might later drop them if they aren't being used.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
fahad yaseen
Starting Member
8 Posts |
Posted - 2014-08-05 : 15:57:46
|
| mam please help me in detail answerthanksfadi |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-05 : 16:01:10
|
| That's as detailed as I can get given the information provided.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
??