InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 02:17:12 GMT20http://www.sqlservercentral.com/Forums/Topic672308-360-1.aspxhttp://msdn.microsoft.com/en-us/library/aa174523(SQL.80).aspxhttp://msdn.microsoft.com/en-us/library/aa933131(SQL.80).aspxgo through these..........;)Thu, 12 Mar 2009 04:50:21 GMTjk.returnshttp://www.sqlservercentral.com/Forums/Topic672308-360-1.aspxHave you looked in Books On Line?A few general rules of thumb (and remember in SQL Server everything comes with an "It depends" attached):1. Every table should have a clustered index.2. The clustered index should be on a monotonically increasing value because the index IS the leaf level of the data (the data is physically stored in this order).3. The clustered index key should be narrow because the clustered index is included in the non-clustered indexes.4. Clustered indexes tend to be better for range queries while non-clustered indexes tend to perform better for equality queries.Here's a link to a list blog posts by Gail Shaw (gilamonster here on SSC) that provide good index information:[url]http://sqlinthewild.co.za/index.php/category/sql-server/indexes/[/url]Tue, 10 Mar 2009 07:22:25 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic672308-360-1.aspxHi.. I am new to Index in SQL Server. Pls provide some info aboutWhen to use Clustered Index & Non-Clustered Index?What are the advantages & dis advantages of Clustered Index?What are the advantages & dis advantages of Non-Clustered Index?ThanksTue, 10 Mar 2009 05:49:47 GMTsharma-691993