如何减少简单选择查询的响应时间?

MarketPlane 表包含超过 6000 万行.

MarketPlane table contains more than 60 million rows.

当我需要特定日期的飞机总数时，我执行此查询需要超过 7 分钟.我怎样才能减少这个时间?

When I need the total number of plane from a particular date, I execute this query which takes more than 7 min. How can I reduce this time ?

SELECT COUNT(primaryKeyColumn) 
FROM   MarketPlan 
WHERE  LaunchDate > @date

我已经实现了您链接中提到的所有内容，即使现在我已经实现了 With(nolock)，它将响应时间减少到 5 分钟.

I have implemented all things mentioned in your links even now I have implemented With(nolock) which reduce response time is to 5 min.

您必须在表上创建索引，或者按日期对表进行分区.

您可能还想看看

SQL Server 2000/2005 索引视图性能调整和优化技巧

SQL Server 索引视图

推荐阅读

热点文章