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 |
|
abcd
Yak Posting Veteran
92 Posts |
 Posted - 2009-01-08 : 01:01:37
|
| hi all.......i am here to gain some knowledge about using indexing in sql..what type of indexing should be used if database consist of few records and what indexing should be done while dealing with large database??? any other information about indexes is also welcome.... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Nageswar9
Aged Yak Warrior
600 Posts |
Posted - 2009-01-08 : 01:28:36
|
| Clustered Index:-Clustered indexes sort and store the data rows in the table or view based on their key values. These are the columns included in the index definition. There can be only one clustered index per table, because the data rows themselves can be sorted in only one order. |
 |
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
|
|
abcd
Yak Posting Veteran
92 Posts |
Posted - 2009-01-08 : 02:50:28
|
| thnks a lot....i am going through all the particles provided by all of you..:):) |
|
|
|
abcd
Yak Posting Veteran
92 Posts |
Posted - 2009-01-08 : 02:55:07
|
| ooops i meant articles...:) |
|
|
|
|
|
|
indexes