June 1, 2005 at 2:29 am
hi
i am new to sql server.i am not understanding what is the Clustered index and non-Clustered index and what is the difference between them
Your ideas will be highly appreciated.
regards.
venu madhav.T
9848898323
June 1, 2005 at 2:31 am
BOL and http://www.sqlservercentral.com/columnists/chedgate/clusterthatindex.asp
http://www.sqlservercentral.com/columnists/chedgate/clusterthatindexparttwo.asp
http://www.sqlservercentral.com/columnists/chedgate/clusterthatindexpart2.asp
is a good start.
The "main" difference is to understand, that a clustered index is actually the data, while a nonclustered index is a separate physical ondisk structure
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply