我有一个表的结构为:CREATE TABLE [test] (
[YearMonth] [smalldatetime] NOT NULL ,
[UserID] [char] (8) NOT NULL ,
[UserName] [varchar] (30) NOT NULL ,
[OfficeName] [varchar] (30) NOT NULL ,
[FactoryCode] [char] (2) NOT NULL ,
[FactoryName] [varchar] (40) NOT NULL ,
[Day1] [bit] NULL DEFAULT (0),
.
.
.
[Day31] [bit] NULL DEFAULT (0),
[Re] [varchar] (100) NULL ,
[RegisteredDatetime] [datetime] NOT NULL ,
[RegisteredName] [varchar] (30) NOT NULL ,
PRIMARY KEY CLUSTERED
(
[YearMonth],
[UserID],
[FactoryCode]
) ON [PRIMARY]
GO该表具体的数据量不确定(应该比较大),经常需要根据YearMonth,UserID或者YearMonth,FactoryCode进行检索,现在有个问题是,按照自动建立的主键的聚集索引,数据是按照YearMonth,UserID,FactoryCode进行排序的,但我只需要按照YearMonth,UserID排序,FactoryCode保持插入时候的顺序,我应该怎么做呢?谢谢
[YearMonth] [smalldatetime] NOT NULL ,
[UserID] [char] (8) NOT NULL ,
[UserName] [varchar] (30) NOT NULL ,
[OfficeName] [varchar] (30) NOT NULL ,
[FactoryCode] [char] (2) NOT NULL ,
[FactoryName] [varchar] (40) NOT NULL ,
[Day1] [bit] NULL DEFAULT (0),
.
.
.
[Day31] [bit] NULL DEFAULT (0),
[Re] [varchar] (100) NULL ,
[RegisteredDatetime] [datetime] NOT NULL ,
[RegisteredName] [varchar] (30) NOT NULL ,
PRIMARY KEY CLUSTERED
(
[YearMonth],
[UserID],
[FactoryCode]
) ON [PRIMARY]
GO该表具体的数据量不确定(应该比较大),经常需要根据YearMonth,UserID或者YearMonth,FactoryCode进行检索,现在有个问题是,按照自动建立的主键的聚集索引,数据是按照YearMonth,UserID,FactoryCode进行排序的,但我只需要按照YearMonth,UserID排序,FactoryCode保持插入时候的顺序,我应该怎么做呢?谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货