• Contact

  • Newsletter

  • About us

  • Delivery options

  • Prospero Book Market Podcast

  • Oracle High-Performance SQL Tuning

    Oracle High-Performance SQL Tuning by Burleson, Donald;

      • GET 10% OFF

      • The discount is only available for 'Alert of Favourite Topics' newsletter recipients.
      • Publisher's listprice GBP 68.99
      • The price is estimated because at the time of ordering we do not know what conversion rates will apply to HUF / product currency when the book arrives. In case HUF is weaker, the price increases slightly, in case HUF is stronger, the price goes lower slightly.

        32 959 Ft (31 390 Ft + 5% VAT)
      • Discount 10% (cc. 3 296 Ft off)
      • Discounted price 29 664 Ft (28 251 Ft + 5% VAT)

    32 959 Ft

    db

    Availability

    printed on demand

    Why don't you give exact delivery time?

    Delivery time is estimated on our previous experiences. We give estimations only, because we order from outside Hungary, and the delivery time mainly depends on how quickly the publisher supplies the book. Faster or slower deliveries both happen, but we do our best to supply as quickly as possible.

    Product details:

    • Publisher McGraw Hill
    • Date of Publication 16 August 2001

    • ISBN 9780072190588
    • Binding Paperback
    • No. of pages656 pages
    • Size 231x182x37 mm
    • Weight 1250 g
    • Language English
    • 0

    Categories

    Long description:

    Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


    From the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal execution


    This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.


    Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


    From the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal execution


    This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.

    More

    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 OperatorsIndex

    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

    <$TSpAbove=165;>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

    More

    0