Id int identity(1,1) primary key
I spend a good bit of time over the years tuning slow code. A simple identity column can speed up code compared to a Heap. Is it always the best possible PK? No.
CREATE TABLE [dbo].[SampleTable1](
id int identity(1,1) primary key,
[f_name] [varchar](24) NULL,
[addresss] [varchar](50) NULL)
CREATE TABLE [dbo].[SampleTable1](
id int identity(1,1) primary key,
[f_name] [varchar](24) NULL,
[addresss] [varchar](50) NULL)
People will argue endlessly over PKs and Clusters. Without a cluster Inserts are slower. Very rarely do we see a single disk server or a 5 spindle RAID array. The more spindles in a san the more exterme the fragmentation.
0 Comments:
Post a Comment
<< Home