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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 DB Performance - Indexes

Author  Topic 

andriancruz
Starting Member

38 Posts

Posted - 2008-10-16 : 02:29:02
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:32
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112663
Go to Top of Page
   

- Advertisement -