Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database
暫譯: 專家級 Oracle 索引與存取路徑：為您的資料庫達到最佳效能
Darl Kuhn, Sam R Alapati, Bill Padfield
商品描述
Speed up the execution of important database queries by making good choices about which indexes to create. Choose correct index types for different scenarios. Avoid indexing pitfalls that can actually have indexes hurting performance rather than helping. Maintain indexes so as to provide consistent and predictable query response over the lifetime of an application.
Expert Oracle Indexing and Access Paths is about the one database structure at the heart of almost all performance concerns: the index. Database system performance is one of the top concerns in information technology today. Administrators struggle to keep up with the explosion of access and activity driven by the proliferation of computing into everything from phones to tablets to PCs in our increasingly connected world. At the heart of any good-performing database lies a sound indexing strategy that makes appropriate use of indexing, and especially of the vendor-specific indexing features on offer.
Few databases fully exploit the wealth of data access mechanisms provided by Oracle. Expert Oracle Indexing and Access Paths helps by bringing together information on indexing and how to use it into one blissfully short volume that you can read quickly and have at your fingertips for reference. Learn the different types of indexes available and when each is best applied. Recognize when queries aren’t using indexes as you intend. Manage your indexing for maximum performance. Confidently use the In Memory column store feature as an alternate access path to improve performance. Let Expert Indexing in Oracle Database 12c be your guide to deep mastery of the most fundamental performance optimization structure in Oracle Database.
- Explains how indexes help performance, and sometimes hinder it too
- Demystifies the various index choices so that you can chose rightly
- Describes the database administration chores associated with indexes
- Demonstrates the use of the In Memory column store as an alternate access path to the data
What You Will Learn
- Create an overall indexing strategy to guide your decisions
- Choose the correct indexing mechanisms for your applications
- Manage and maintain indices to avoid degradation and preserve efficiency
- Take better advantage of underused index types such as index-organized tables
- Choose the appropriate columns to index, with confidence
- Blend partitioning and materialized views into your indexing strategy
商品描述(中文翻譯)
加速重要資料庫查詢的執行，透過明智的選擇來決定創建哪些索引。根據不同情境選擇正確的索引類型。避免索引陷阱，這些陷阱可能會使索引的效能下降而非提升。維護索引，以便在應用程式的整個生命週期中提供一致且可預測的查詢回應。
《專家級 Oracle 索引與存取路徑》是關於幾乎所有效能問題核心的資料庫結構：索引。資料庫系統效能是當今資訊科技中最重要的關注之一。管理員在面對從手機到平板電腦再到個人電腦的計算普及所驅動的存取和活動激增時，努力跟上這一變化。任何高效能資料庫的核心都在於一個合理的索引策略，這個策略適當地利用索引，特別是利用供應商特定的索引功能。
很少有資料庫能充分利用 Oracle 提供的豐富資料存取機制。《專家級 Oracle 索引與存取路徑》通過將有關索引及其使用的信息整合到一本簡短的書籍中，幫助讀者快速閱讀並隨時參考。了解可用的不同類型索引以及每種索引最佳應用的時機。識別查詢未如預期使用索引的情況。管理您的索引以達到最佳效能。自信地使用 In Memory 列存儲功能作為替代存取路徑以提升效能。讓《Oracle Database 12c 專家級索引》成為您深入掌握 Oracle Database 中最基本效能優化結構的指南。
- 解釋索引如何幫助效能，有時也會妨礙效能
- 解開各種索引選擇的神秘，使您能夠正確選擇
- 描述與索引相關的資料庫管理工作
- 演示如何使用 In Memory 列存儲作為數據的替代存取路徑
您將學到的內容：
- 創建整體索引策略以指導您的決策
- 為您的應用程式選擇正確的索引機制
- 管理和維護索引以避免效能下降並保持效率
- 更好地利用未充分使用的索引類型，例如索引組織表
- 自信地選擇適當的列進行索引
- 將分區和物化視圖融入您的索引策略
本書適合對象：
《專家級 Oracle 索引與存取路徑》適合所有級別的資料庫管理員和應用程式開發人員，特別是那些在資料庫效能和可擴展性挑戰中掙扎的人。任何涉及索引的資料庫管理員，無論是什麼樣的資料庫管理員，都會欣賞這本書中豐富的建議。
