On Thu, Nov 14, 2013 at 4:05 PM, Rafael Copquin <rcopquin@fibertel.com.ar>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: ProFox@leafe.com

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+5c8jeu8rwYRfSVKsXTRKvtKQrZGcangduhWTpOkiA@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.