IS Primary Key Always Better ?

Question

I created a table 'Employee' .In this table colums are Id,Name,Age,Department

.I set Primary Key for Id Column...

When Primary key setting,Creating Clustered Index Defualtly..

When Insert millions Of record,s,Each insertion ,table is sorting with the order of index

,,This will make slow,,,?

Iam Confusing With Clusterd Idexing ,NonClustered Indexing and Primary Key

Any can Help me With Suitable Examples(With Videos)?????

Jignesh Trivedi · Answer

hi As you know Primary key is required to be uniquely referenced. In cluster index physical records are in this sort order on disk.clustered index is therefore the ordering of the physical data rows in accordance with the index blocks that point to them. so yes cluster index may affect the performance. but if you create cluster index (or Primary key) on numeric field than we can reduced somewhat performance hit. Please refer http://www.codeproject.com/Articles/234399/Database-performance-optimization-part-1-Indexing hope this will help you.

Senthil Kumar · Answer

http://msdn.microsoft.com/en-us/library/ms190457.aspx h ave a look in this site will give u a clear guidance.