改善表现 [英] Improve the performance

问题描述

Hi Experts

我有一个表"drv_veh_asn"，其中有14,92,046行，执行时间为

桌子是00:19秒.

您有什么主意吗，如何改善桌子的性能?

请帮帮我.............

此致
Vijay

Hi Experts

I have a table "drv_veh_asn" which having 14,92,046 rows and execution time of

the table is 00:19 sec.

Do u have any Idea, How can I improve the performance of the table.

Please Help me.............

Regards,
Vijay

推荐答案

如果所有索引都很好，并且您的查询已经过微调，则使用维护计划，您可以获得更好的结果.

If all the indexes are fine and your query is fine tuned then using maintanance plan you can get some better results.

您好，

检查这些链接.

在SQL Server中优化数据访问的前10个步骤:第五部分(优化数据库文件并应用分区) [用于优化的方法是什么SQL Server上的大表(+ 1M行) [针对大型SQL Server表的最佳优化(100-200百万条记录) [如何优化SQL Server表? [ ^ ]

希望对您有所帮助.

Hi,

check these links.

Top 10 steps to optimize data access in SQL Server: Part V (Optimize database files and apply partitioning)[^]
What''s your approach for optimizing large tables (+1M rows) on SQL Server[^]
Best optimizing for a large SQL Server table (100-200 Mil records)[^]
How to Optimize SQL Server Table?[^]

Hope it helps.

这篇关于改善表现的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！