Oracle SQL Tuning & CBO Internals: Based Optimizer with CBO Internals and SQL Tuning Optimization - Brossura

Floss, Kimberly

Brossura

ISBN 10: 0974599336 ISBN 13: 9780974599335

Casa editrice: RAMPANT TECHPRESS, 2004

Riassunto

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 within Oracle 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.

Su questo libro

L'autore:

Kimberly Floss is the president of the International Oracle Users Group (IOUG) , specializing in Oracle performance tuning and SQL tuning techniques. She has over 15 years of experience in information technology, with specific focus on relational database technology including Oracle, DB2, Microsoft SQL Server, and Sybase. She lives in Chicago.

Contenuti:

Introduction
Cost based SQL optimizer
SQL execution internals
SQL extensions for performance
Coding for performance

Su questa edizione

• Editore: RAMPANT TECHPRESS
• Data di pubblicazione: 2004
• ISBN 10: 0974599336
• ISBN 13: 9780974599335
• Rilegatura: Copertina flessibile
• Numero edizione: 2
• Numero di pagine: 330