2010年5月13日
Statistical Indexes
摘要： SQL Server 2000 and 2005 both use a "cost-based" optimizer to quickly locate data in its databases.Indexes are actually internal tables, and work like the index in a book – it contains a list of... 阅读全文
posted @ 2010-05-13 11:53 programming snail 阅读(377) 评论(0) 推荐(0)
Performance Tuning: Implementing Indexes
摘要： ne of the most important knobs and levers you have in tuning a system from the database perspective is in your database'sindexes. The indexes you apply (or don’t apply) can create performance ga... 阅读全文
posted @ 2010-05-13 11:41 programming snail 阅读(228) 评论(0) 推荐(0)
Understanding SQL Server Query Plans
摘要： ore than any other tuning you can perform; creating efficient queries will always give you the most return for your time and effort. I've managed to squeeze a few more percentage points of performance... 阅读全文
posted @ 2010-05-13 11:33 programming snail 阅读(414) 评论(0) 推荐(0)