在sql server中定义表性能 [英] Define table performance in sql server

问题描述

当我在sqlserver中创建新表时，我必须做什么或者记得将表的性能提高到SELECT，INSERT，UPDATE和DELETE。

Hi,

when i create new table in sqlserver, what are mandatory things i have to do or remember for increase performance of table to SELECT,INSERT,UPDATE and DELETE.

推荐答案

查看此处



http://technet.microsoft.com/en -us / library / ms172432（v = sql.110）.aspx [ ^ ]

查看此链接希望这对您有所帮助。



http://www.dotnet-tricks.com/Tutorial/sqlserver/bM6H260812-Tips-to-improve-SQL-Server-database-design-and-performance.html [ ^ ]



数据库性能优化第1部分（索引策略） [ ^ ]



http： //www.databasejournal.com/sqletc/article.php/1576231/SQL-Server-Optimization-Tips-for-Designing-Tables.htm [ ^ ]

Check this links hope this will help you.

http://www.dotnet-tricks.com/Tutorial/sqlserver/bM6H260812-Tips-to-improve-SQL-Server-database-design-and-performance.html[^]

Database performance optimization part 1 (Indexing strategies)[^]

http://www.databasejournal.com/sqletc/article.php/1576231/SQL-Server-Optimization-Tips-for-Designing-Tables.htm[^]

请参阅..

http ：//www.sqlshack.com/index-strategies-part-1-choosing-right-table-structure/ [ ^ ]

这篇关于在sql server中定义表性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！