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:14:22
|
| ?? |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-08-04 : 10:40:12
|
| generally a primary key column is the best candidate for clustered index.1.it is narrow2.used in joins3.uniqueness of dataindexing a column depends on how you use the column.Javeed Ahmed |
 |
|
|
fahad yaseen
Starting Member
8 Posts |
Posted - 2014-08-04 : 10:44:12
|
| so i should go with clustered index according to given scenario?fadi |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-08-05 : 04:29:09
|
| no,go for a nc index.Javeed Ahmed |
|
|
|
fahad yaseen
Starting Member
8 Posts |
Posted - 2014-08-05 : 15:54:51
|
| ahmed bhai plz answer my this question in detail why should i go with non clustered index?? pleasefadi |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-05 : 16:01:31
|
| I whole heartedly disagree with ahmed.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
misken
Starting Member
8 Posts |
Posted - 2014-08-06 : 03:51:35
|
| Im quite confused by the question. It doesnt seem to supply any useful information to make the choice between n-c or clustered index.But dont trust me on this, im still learning more about it.Sys.developer/accidental DBA |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-08-06 : 06:23:46
|
| Tkizer,with the huge experiece you have i totally agree with you that you disagree with my answer.Can you pour some light on the same.Javeed Ahmed |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
??