In an internal experimental test, the Design Advisor was able to increase the performance of an un-tuned DB2 UDB database by 84%!
在内部实验的测试中，Design Advisor可以将未调优的DB 2UDB数据库性能提高84% ！
If the database is suspect and 2000 or earlier, a secondary option can be to try to "un-suspect" the database using sp_resetstatus.
如果数据库是置疑的并且Sql Server的版本是2000或者更早，第二选择可以是尝试着使用sp_resetstatus “去置疑”数据库。
Indexing speed is super-fast, because it talks directly to the database. Any slowness will come from complex SQL queries and un-indexed foreign keys and other such problems.
由于直接跟数据库对话，它建立索引的速度超快，除非你的SQL语句非常复杂，或者某个列没有使用索引。
Indexing speed is super-fast, because it talks directly to the database. Any slowness will come from complex SQL queries and un-indexed foreign keys and other such problems.
由于直接跟数据库对话，它建立索引的速度超快，除非你的SQL语句非常复杂，或者某个列没有使用索引。
应用推荐