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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-12 : 08:14:58
|
| Muthu writes "we have one laksh data in the server ,if i create an index ,is it useful for our database,can u explain the relationship b/w the data acccessing and index" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-12 : 08:19:47
|
| Creating an index will be useful when searching for recordsSee index in Books On LineMadhivananFailing to plan is Planning to fail |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-10-12 : 09:49:54
|
| Imagine a phone book, or other drectory with a laksh of names. Is it better (for you using the directory) when the names are ordered by last name, or if they are randomly placed?Same thing will apply to any database. Keep in mind as well, that indexes can be useless to some queries. Consider if you are looking for all people whose names end in "son" (Nelson, Olaffson, Robertson...) |
|
|
|
|
|
|
Clarify the doubt