Clustered Index Vs Non Clusterd

Posted Date: 03 Jul 2008 Resource Type: Definitions Category: General

Posted By: M. Irfan Member Level: Gold
Rating:

Points: 3

Clustered Index Vs Non Clusterd

The major differences is you can have Only One Clustered index for each table.But you can have multiple Non-Clustered Index for that table.(249 Non clustered index on a single table)
Normally Clustered index built upon the Primary Key. Because Clustered Index order the rows according to the order of physical data of that table.(Hence it only can be one per table, as physically you can arrange a table in one way)
Non-Clustered index doesn't need to based on physical order, they order the index by logical order. Leaf node of non-clustered index doesn't contain data page, leaf nodes contain index rows.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Sql Server .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Brief explination about how ASP.NET authentication process works............
	Previous Resource: Difference B/w Execute NonQuery and Execute Scalar
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

web conferencing