Kevin Meade

Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities

(No reviews yet) Write a Review
ISBN 13:
9781501022692
author:
Kevin Meade
format:
Paperback
publisher:
CreateSpace Independent Publishing Platform
language:
English
Publication Year:
2014
Pages:
568
Dimensions:
19 x 3.3 x 23.5 cm
Genre:
Computing & Internet, Databases, Data Storage & Management, Kevin Meade,Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities,CreateSpace Independent Publishing Platform,1501022695,Computers,Computers - Data Base Management
Condition:
New
Availability:
Item usually sent within 7 working days
£37.75

Description

This comprehensive guide to Oracle SQL performance tuning and optimization provides an in-depth process for discovering, analyzing, and resolving problems. Written by a seasoned database administrator with thirty years of experience working with the Oracle RDBMS, this book teaches the science behind SQL tuning using the cardinality-based method.

Learn how to identify a query's driving table and join order, construct query diagrams, data models, and join trees, and build and use count/filter/reconstruction queries. Discover techniques for identifying waste in a query execution plan, zeroing in on cardinality divergence, and exploiting the 2% rule to analyze access methods and join methods.

With expert guidance, you'll learn how to perfect your question-based analysis technique, manage statistics, and deal with common statistics problems. The book includes a special chapter for EXADATA, a lab demonstrating the cardinality-based process of SQL tuning, and twenty-three magical SQL scripts that make the process of SQL tuning easy to do.

View AllClose

Related Products

Related Products

Mastering Oracle SQL
Add to Cart
Quick view

Mastering Oracle SQL

Mishra, Sanjay

£32.91
Mastering Oracle SQL, 2nd Edition provides expert guidance for those who want to unlock the full potential of Oracle SQL. This comprehensive guide covers the latest version of Oracle, Oracle 10g, and...
Learning Oracle PL/SQL
Add to Cart
Quick view

Learning Oracle PL/SQL

Pribyl, Bill

£32.91
Get started with Oracle's powerful programming language for stored procedures and unlock a world of possibilities for your database programs.PL/SQL supplements SQL with procedural features, including...