Australasia's Biggest Online Store

New Zealand's Lowest Prices. Guaranteed

Oracle High-performance SQL Tuning
By

Rating
Product Details

Table of Contents

PART I Background 1 Introduction to SQL 2 Overview of Oracle SQL Extensions 3 Understanding SQL Execution 4 Overview of the SQL Optimizers 5 SQL Internal Processing 6 Tuning SQL Table Access PART II Basic SQL Tuning 7 The Steps to Oracle SQL Tuning 8 Understanding Oracle SQL Utilities 9 Locating Significant SQL Statements 10 Tuning Full-Table Scans and Parallel Query 11 Optimizing Sorting for Oracle SQL Statements 12 Tuning with Oracle Hints 13 Tuning with Optimizer Plan Stability 14 Tuning with the Cost-Based Optimizer 15 Tuning with the Rule-Based Optimizer 16 Tuning Table Joins PART III Advanced SQL Tuning 17 Tuning SQL DML Statements 18 Tuning SQL with Temporary Tables 19 Tuning SQL Subqueries 20 Tuning SQL with Indexes 21 Tuning Data Warehouse SQL 22 SQL Tuning with STATSPACK 23 Tuning SQL with Built-in Functions and Special Operators Index PART I Background 1 Introduction to SQL 2 Overview of Oracle SQL Extensions 3 Understanding SQL Execution 4 Overview of the SQL Optimizers 5 SQL Internal Processing 6 Tuning SQL Table Access PART II Basic SQL Tuning 7 The Steps to Oracle SQL Tuning 8 Understanding Oracle SQL Utilities 9 Locating Significant SQL Statements 10 Tuning Full-Table Scans and Parallel Query 11 Optimizing Sorting for Oracle SQL Statements 12 Tuning with Oracle Hints 13 Tuning with Optimizer Plan Stability 14 Tuning with the Cost-Based Optimizer 15 Tuning with the Rule-Based Optimizer 16 Tuning Table Joins PART III Advanced SQL Tuning 17 Tuning SQL DML Statements 18 Tuning SQL with Temporary Tables 19 Tuning SQL Subqueries 20 Tuning SQL with Indexes 21 Tuning Data Warehouse SQL 22 SQL Tuning with STATSPACK 23 Tuning SQL with Built-in Functions and Special Operators

About the Author

Don Burleson (Kittrell, NC) has 20 years of experience as a database administrator and has written 9 books on database management including Oracle SAP Administration (O'Reilly), High-Performance Oracle8 Tuning, High-Performance Oracle Data Warehousing, High-Performance Oracle Database Applications (Coriolis) and Oracle8 Tuning, German Edition (Sybex). Don has taught more than 100 University courses and regularly conducts in-house Oracle training.

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Oracle High-performance SQL Tuning (Oracle Press Series) on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Back to top