Abdu Rafeeq

Abdu Rafeeq

  • 981
  • 670
  • 89.8k

IS Primary Key Always Better ?

May 29 2013 5:24 AM
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)?????


Answers (2)