Oracle SQL Tuning and CBO Internals

Kimberly Floss - Collection Oracle In-Focus Series

339 pages, parution le 29/09/2004

Ajouter à une liste

Indisponible

Résumé

About this book:

By drawing from the combined expertise of the world's leading Oracle experts, it has been possible to create this indispensable guide to Grade SQL. Tuning Oracle SQL is the single most important skill of the Oracle professional, and Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time.

This text explores important internal mechanisms within Oracle and illustrates 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.

Best of ail, this text comes with a ready-to-use code depot that is full of working SQL tuning scripts. By leveraging on the expertise of the works leading Oracle experts, you can quickly optimize the SQL and indexes inside your Oracle database.

Key Features:

See inside the Oracle Cost-Based Optimizer
Learn the experts' secrets for Turbocharging Oracle SQL
Tune your library cache for super-fast SQL parsing
Understand the internals of Oracle indexing
Explore the internals of SQL execution
Understand optimizer plan stability (stored outlines)
See how hints can change SQL execution plans
Understand multi-level index partitioning

L'auteur - Kimberly Floss

Kimberly Ross is a respected Oracle Database Administrator and President of the International Oracle Users Group (OJG). With more than a decade of experience, Kimberly specializes in Oracle Performance Tuning and is an expert h SQL tuning techniques.

Sommaire

Introducing to SQL Tuning
Cost-Based SQL Optimizer
SQL Execution Internals
SQL Extensions for Performance
Coding for Performance

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Rampant
Auteur(s)	Kimberly Floss
Collection	Oracle In-Focus Series
Parution	29/09/2004
Nb. de pages	339
Format	17,5 x 23
Couverture	Broché
Poids	681g
Intérieur	Noir et Blanc
EAN13	9780974599335
ISBN13	978-0-9745993-3-5