Oracle SQL Tuning & CBO Internals
 |
|
Описание:
As Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time, this book’s timing is critical as tuning Oracle SQL has become the single most important skill of the Oracle professional. While not appropriate for the beginner, this book allows senior Oracle professionals to explore important internal mechanisms withinOracle and the powerful and complex internals of Oracle SQL execution. Topics include the internals of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Also included is a ready-to-use code depot full of working SQL tuning scripts, which allow for quick optimization of the SQL and indexes inside the Oracle database.Похожие книги
 | Oracle Database10G: Data Warehousing Автор: Lilian Hobbs, Susan Hillson, Shilpa Lawande, Pete Smith Год: 2004 |
 | UNIX internals Автор: Pate S. Год: 1996 |
 | Harmonograph: A Visual Guide to the Mathematics of Music Автор: Anthony Ashton Год: 2003 |
| DB2 UDB V8 and WebSphere V5: Performance Tuning and Operations Guide Автор: Chen W.-J. Год: 2004 |