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 |
|
andriancruz
Starting Member
38 Posts |
 Posted - 2008-10-16 : 02:30:27
|
| Hi Everyone,Can anyone explain to me what is the difference between clustered and non clustered index. i know that index help the performance for query to fetching the data.but what is best practice if you design the index. is it good practice to put a lot of index in table for past performance? any explanation will highly appreciated.Thank you & regards,Andie |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-16 : 02:36:43
|
| duplicatehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112662 |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-16 : 11:36:04
|
| This is a wide topic which you really should read up on e.g. http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1239664,00.htmlIndexes improve query performance but slow inserts and updates so it is not simply a case of "the more the merrier" you need to balance the need for fast queries with fast updates for a particular system. This site has a procedure to recommend indexes (which SSMS will also do - again something you need to read up on): http://www.sqlservercentral.com/scripts/Index+Management/63937/ |
|
|
|
andriancruz
Starting Member
38 Posts |
Posted - 2008-10-17 : 01:47:04
|
| Thank you darkdusky for the link. |
|
|
|
|
|
|
DB Performance - Indexes