Online Members

urgent!!!!!!

Posted Date: 01 Jun 2007 Posted By:: vijayavasavi narapuram

Member Level: Silver Member Rank: 0 Points: 2 Responses: 4

Generally in sqlserver,we can create only one clustered index on a table.why can't we create another clustered index on the table?and why can't we create 2 primary keys on 2 columns in a single table?

Responses

#126511 Author: lakshmi Narasimhulu Member Level: Gold Member Rank: 662 Date: 01/Jun/2007 Rating: Points: 2
The clustered index is also related to primary key only.we can have only one primary key only so that we can call it also private key, if u need more than one key u can use foreign key.

#126524 Author: Padma Member Level: Diamond Member Rank: 11 Date: 01/Jun/2007 Rating: Points: 2
Yoyu cannt create 2 primary keys on a table. but you can create composite key Have a good Day

#126534 Author: subashpenugonda Member Level: Bronze Member Rank: 0 Date: 01/Jun/2007 Rating: Points: 2
CHECK THIS LINK ..FOR MORE INFORMATION http://www.sql-server-performance.com/indexes_not_equal.asp

#126551 Author: Vanitha Govindraj Member Level: Gold Member Rank: 0 Date: 01/Jun/2007 Rating: Points: 2
When a clustered index is applied, the data at the "leaf level" contains the actual data pages where you'll find the data being searched on. In a non-clustered index, the data pages at the leaf level merely have pointers to more data pages containing the actual data being searched upon. This being the case, the data pages at the leaf level in a clustered index are only ordered one way, and "in order."

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Rollback transaction:
	Previous : Duplicates
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Active Members
Today

Last 7 Days

more...

Awards & Gifts

Email subscription

Talk to Webmaster Tony John