IS Primary Key Always Better ?

Abdu Rafeeq

13y1.4kSQL

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)?????

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
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.
0
Senthil Kumar13y ago
http://msdn.microsoft.com/en-us/library/ms190457.aspx

have a look in this site will give u a clear guidance.
0