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 |
|
craker
Starting Member
5 Posts |
 Posted - 2010-01-12 : 13:27:30
|
| Hi everybody. I have one question abouts indexs. I made one database about spanish cesus. Now, i need declare index because this database will made stadistics and it will search information.For example ¿must i declare cluster index in each primary key?Other question. Non-clustered index where make sense to declare?Thanks very much |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-12 : 16:28:09
|
| This is a just a general rule and has to be analysed for implemeting onto your criteria , but non - clustered index can be effective where the selectivity of your data is high, in other the more unique the better.Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
|
|
|
index in database