Cluster Index and Non-Cluster Index

Posted Date: 26 Oct 2009	Resource Type: Articles	Category: Databases
Author: Rajesh.Dharmakkan	Member Level: Gold
Rating:	Points: 5

Cluster Index and Non-Cluster Index

Indexing is the most common think in sql server. Users should know about the some basic differences between the Cluster and non cluster indexes.

Cluster Index
1. Only one Cluster index allowed in a table.
2. Index the only one column which are commonly using in a table for search purpose.
3. Use on the columns with low selectivity.
4. Cluster index physically rearrange the table values based on the Indexed column.

Non cluster index

1. Up to 249 indexes allowed per table.
2. Set Non Cluster index for the all columns which will use to the search purpose.
3. Use on the columns with high selectivity.
4. Create a separate list of key values with pointers to the location of the data in the data page.

These are the some basic differences.

Responses

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

Feedbacks

Popular Tags

What are tags ?

Search Tags

Non Cluster index . Differences between cluster and non cluster index . Cluster index .

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: Generate Script for full database with data
	Previous Resource: Transfer Data using Select into
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

More Resources