On Thu, Nov 14, 2013 at 4:05 PM, Rafael Copquin <[email protected]>wrote:
> I would like an explanation of what a clustered index is and the other > types of indexes in SQL Server. > I really don't understand the differences or their significance, > especially in relation to what I have known for years on VFP indexes. > > You seem to be quite a pro in SQL Server so can you help? > > ---------------- The answer here goes over the basics: http://stackoverflow.com/questions/18304376/sql-server-when-to-use-clustered-vs-non-clustered-index Brent Ozar is one to the top consultants in M$SS and this page on his site can start to answer that real big question you asked. Indexes are the #1 tweakable aspect of a schema that will cost you nothing to change and give you great return if you do it well. Indexes follow the Less Is More concept. http://www.brentozar.com/sql/index-all-about-sql-server-indexes/ You have to pay attention to the data type as well as the use of the index to determine what is best. How adding data to the table may poor for one type of index and better for the other. the page of data in an index is better described here. http://technet.microsoft.com/en-us/library/ms190969(v=sql.105).aspx In general Clustered index on an Int key is good. Clustered index on a Guid key is bad. Why takes a while to explain. :) HTH. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyla+5c8jeu8rwyrfsvksxtrkvtkqrzgcangduhwtpo...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
