大话程序猿眼中的聚集索引和非聚集索引

 博客园将不进行维护，转站到我的个人博文：地址

 CREATE TABLE [dbo].[Student](

 [ID] [INT] IDENTITY(1,1) NOT NULL,

 [Name] [NVARCHAR](50) NOT NULL,

 [Age] [INT] NOT NULL,

 [Height] [INT] NOT NULL,

 [Address] [NVARCHAR](100) NULL,

 [Class] [NVARCHAR](50) NOT NULL,

 [EntranceDateTime] [DATETIME] NOT NULL,

 CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED

(

 [ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

 

GO

ALTER TABLE [dbo].[Student] ADD CONSTRAINT [DF_Student_EntranceDateTime] DEFAULT (GETDATE()) FOR [EntranceDateTime]

GO

  往表里插入 500万数据：

DECLARE @i INT;

SET @i=1;

WHILE(@i<5000001)BEGIN

 

INSERT INTO dbo.Student(Name,Age,Height,[Address],Class,EntranceDateTime)

VALUES('yang_'+CONVERT(NVARCHAR(10),@i),RAND()*10+7,RAND()*100+50,'厦门土豪小区1座'+CONVERT(NVARCHAR(10),CONVERT(INT,RAND()*100+1))+'号',CONVERT(NVARCHAR(10),CONVERT(INT,RAND()*6+1))+'年级',GETDATE())

SET @i=@i+1;

END

 

 

     

　　

 

Ø [Col1] = 3.14

 

Ø [Col1] > 100

 

Ø [Col1] BETWEEN 0 AND 99

 

Ø [Col1] LIKE 'abc%'

 

Ø [Col1] IN (2, 3, 5, 7)

Ø ABS([Col1]) = 1

 

Ø [Col1] + 1 = 9

 

Ø [Col1] LIKE '%abc'

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有