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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2010-09-01 : 07:55:25
|
| 1.what is clustered and non-clustred index ?2.when i use each of them? |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-09-01 : 08:16:00
|
http://weblogs.sqlteam.com/mladenp/archive/2007/09/18/Back-To-Basics-What-is-a-Clustered-and-a-Non-Clustered.aspx
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-09-01 : 14:06:31
|
| i have column "OBRGDT" - hold dates dataOBRGDT2010102201010320101042010105......what i choose clustered or non clustered?when i need to choose non clustered on combinations of columns andwhen on single column ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-09-02 : 02:32:27
|
| i read it.i have aonther question:i have table with 1M rows with column "STATUS"STATUS12half rows have status=1 and another have status=2is it selectivity high or low?should i build on it index (cluster or non cluster)? |
|
|
|
|
|
|
index