我正在努力提高运行速度很慢的查询的性能.经过实际执行计划;我发现集群索引寻求占82％.有什么办法可以提高Index Index的表现吗？以下是执行计划以及索引和表所使用的Index Seek问题的图像.
alt text http://img340.imageshack.us/img340/1346/seek.png
指数：
/****** Object: Index [IX_Stu] Script Date: 12/28/2009 11:11:43 ******/ CREATE CLUSTERED INDEX [IX_Stu] ON [dbo].[stu] ( [StuKey] ASC )WITH (PAD_INDEX = OFF,SORT_IN_TEMPDB = OFF,DROP_EXISTING = OFF,IGNORE_DUP_KEY = OFF,ONLINE = OFF) ON [PRIMARY]
表(为简洁起见,省略了一些列)：
CREATE TABLE [dbo].[stu]( [StuCertKey] [int] IDENTITY(1,1) NOT NULL,[StuKey] [int] NULL CONSTRAINT [PK_Stu] PRIMARY KEY NONCLUSTERED ( [StuCertKey] ASC )WITH (PAD_INDEX = OFF,FILLFACTOR = 80) ON [PRIMARY] ) ON [PRIMARY]
