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 narrow
2.used in joins
3.uniqueness of data
indexing 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?? please
fadi |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-05 : 16:01:31
|
I whole heartedly disagree with ahmed.
Tara Kizer
SQL Server MVP since 2007
http://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 |
|
|
|
|
|
??