Expert Performance Indexing in SQL Server

Jason Strate

  • 出版商: Apress
  • 出版日期: 2015-11-10
  • 售價: $1,860
  • 貴賓價: 9.5$1,767
  • 語言: 英文
  • 頁數: 432
  • 裝訂: Paperback
  • ISBN: 1484211197
  • ISBN-13: 9781484211199
  • 相關分類: MSSQLSQL
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

This book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. You’ll better understand what indexes are doing in the database and what can be done to mitigate and improve their effect on performance. The final destination is a guided tour through a number of real life scenarios showing approaches you can take to investigate, mitigate, and improve the performance of your database.

  • Defines the types of indexes and their implementation options
  • Provides use cases and common patterns in applying indexing
  • Describes and explain the index metadata and statistics
  • Provides a framework of strategies and approaches for indexing databases

商品描述(中文翻譯)

這本書深入探討了良好性能的可能最重要的方面:索引以及如何最佳地使用它們。書籍從淺水區開始,解釋了索引的類型以及它們在數據庫中的存儲方式。隨著深入探討和書籍的進一步發展,您將研究索引和索引上累積的統計數據。您將更好地了解索引在數據庫中的作用,以及可以採取哪些措施來減輕和改善它們對性能的影響。最終目的地是通過一系列真實場景的導覽,展示您可以採取的方法來調查、減輕和改善數據庫的性能。

本書包括以下內容:
- 定義索引的類型和實現選項
- 提供索引應用的使用案例和常見模式
- 描述和解釋索引的元數據和統計數據
- 提供索引數據庫的策略和方法框架