27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [dbo].[TRACK_LOG](
[T_SEQ] [bigint] IDENTITY(1,1) NOT NULL,
[O_ACCOUNT] [varchar](10) NOT NULL,--所属账号
[O_NAME] [varchar](30) NOT NULL,--所属名称
[A_DATE] [date] NOT NULL,--发生日期
[P_NAME] [varchar](128) NOT NULL,--項目名称
[PIA_OWNER] [varchar](30) NULL,--个人账号
......................
)
--非聚集索引
CREATE NONCLUSTERED INDEX IX_1
ON TRACK_LOG (A_DATE)
INCLUDE (O_ACCOUNT, O_NAME,P_NAME, PIA_OWNER);
GO
--聚集索引
CREATE CLUSTERED INDEX IX_2
ON TRACK_LOG (A_DATE)
GO
--查询SQL
select A_DATE,O_ACCOUNT, O_NAME,P_NAME, PIA_OWNER from TRACK_LOG where A_DATE>'2015-5-25'
CREATE NONCLUSTERED INDEX IX_1
ON TRACK_LOG (A_DATE)
INCLUDE (O_ACCOUNT, O_NAME,P_NAME, PIA_OWNER);
GO
select * from TRACK_LOG where PIA_OWNER like '%@PIA_OWNER%‘ and P_NAME like '%@P_NAME%' and
A_DATE>= '2015-01-01' AND A_DATE<= '2015-05-31'