是单独对Event_GUID设的索引,还是几个字段的联合索引?最好是前者。
另外,你的数据量很大,更新的内容很多,可以把超时设长一些。
另外,你的数据量很大,更新的内容很多,可以把超时设长一些。
解决方案 »
- 请高手帮忙解决这个报表的问题
- SQL如何查询小于本记录ID号的记录???????????
- 问个关于存储过程的问题
- sql server 2008 未能解决的问题
- 数据库的大小超过了data文件夹所在的分区大小怎么办?
- 各位高手帮忙,怎么解决这个sql语句,要在sqlserver和access里都能用的?
- 存储过程中拼合sql遇到的单引号问题
- 有很多单位,用不同的数据库,领导让我写一个有关统一数据库,制定一个数据库标准的文章。
- 为什么在查询分析器运行存储过程时有效,在程序里就不起作用?
- 如何在ORACLE启动时执行一个自定义的存储过程
- Access转SQLServer以后数据库文件变大
- 选出重复的记录
单独设置这个超时时长有用吗?
CREATE TABLE [dbo].[EVENT](
[EVENT_GUID] [char](36) COLLATE Chinese_PRC_CI_AS NOT NULL,
[CALLTYPE] [char](1) COLLATE Chinese_PRC_CI_AS NULL,
[CUSTOMER_GUID] [char](36) COLLATE Chinese_PRC_CI_AS NULL,
[DNIS] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[ANI] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[TRANSFERFROM] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[TRANSFTERTO] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[CALLSTARTTIME] [datetime] NULL,
[CALLENDTIME] [datetime] NULL,
[HANGUPTYPE] [char](1) COLLATE Chinese_PRC_CI_AS NULL,
[WORKSTARTTIME] [datetime] NULL,
[WORKENDTIME] [datetime] NULL,
[CALLRESULT_ID] [char](6) COLLATE Chinese_PRC_CI_AS NULL,
[CALLRESULTREASON_ID] [char](6) COLLATE Chinese_PRC_CI_AS NULL,
[HANDLEBY_ID] [char](6) COLLATE Chinese_PRC_CI_AS NULL,
[HANDLEGROUP_ID] [char](6) COLLATE Chinese_PRC_CI_AS NULL,
[SATISFIEDRATE] [char](6) COLLATE Chinese_PRC_CI_AS NULL,
[STRINGFIELD1] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[STRINGFIELD2] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[ATTACHEDDATA] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[OBJECTIVESTATUS] [char](6) COLLATE Chinese_PRC_CI_AS NULL,
[CALLBEGINTIME] [datetime] NULL,
[CALLESTABLISHED] [int] NULL,
[RECORD_GUID] [char](36) COLLATE Chinese_PRC_CI_AS NULL,
[transferresult] [int] NULL,
[comments] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]该表总共建了6个索引:
CREATE NONCLUSTERED INDEX [ix_event_workstarttime] ON [dbo].[EVENT]
(
[WORKSTARTTIME] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]CREATE NONCLUSTERED INDEX [ix_event_dnis] ON [dbo].[EVENT]
(
[DNIS] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]CREATE NONCLUSTERED INDEX [ix_event_customer_guid] ON [dbo].[EVENT]
(
[CUSTOMER_GUID] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]CREATE NONCLUSTERED INDEX [ix_event_callstarttime] ON [dbo].[EVENT]
(
[CALLSTARTTIME] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]CREATE NONCLUSTERED INDEX [handleby_id] ON [dbo].[EVENT]
(
[HANDLEBY_ID] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]CREATE NONCLUSTERED INDEX [EVENT_GUID] ON [dbo].[EVENT]
(
[EVENT_GUID] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]可就是UPDATE Event SET Event_GUID='9A3BC39F-213B-434C-8AB8-857CB9665946',CallType='1',Customer_GUID='FA9EB93A-042F-45C9-950F-3D18F1C809A9',DNIS='2138429999',ANI='013506435188',TransferFrom=NULL,TransfterTo=NULL,CallStartTime='2009-06-12 13:09:22',CallEndTime='2009-06-12 13:18:00',HangupType='1',WorkStartTime='2009-06-12 13:09:22',WorkEndTime='2009-06-12 13:19:40',CallResult_ID='CLOSE',HandleBy_ID='E8C3DD',HandleGroup_ID='campn',StringField1='CTI',CALLBEGINTIME='2009-06-12 13:09:19',CALLESTABLISHED=1,COMMENTS='订购' WHERE Event_GUID='9A3BC39F-213B-434C-8AB8-857CB9665946'
更新这样的记录就报”超时已过期“. 如何解决????