Oracle SQL Tuning Pocket Reference

Publisher : "O'Reilly Media, Inc."

ISBN-13 : 0596552130

Page : 110 pages

Rating : 4.5/5 from 130 voters

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. Mark also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problem/solution scenarios for the optimizers, Mark provides a number of handy SQL tuning tips. He discusses the various optimizer hints, telling you when they can be used to good effect. Finally, Mark discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.

More Books:

Oracle SQL Tuning Pocket Reference
Language: en
Pages: 110
Authors: Mark Gurry
Categories: Computers
Type: BOOK - Published: 2002-01-01 - Publisher: "O'Reilly Media, Inc."

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute effic
Oracle SQL Tuning
Language: en
Pages:
Authors: Mark Gurry
Categories:
Type: BOOK - Published: 2002 - Publisher:

Oracle SQL*Plus Pocket Reference
Language: en
Pages: 146
Authors: Jonathan Gennick
Categories: Computers
Type: BOOK - Published: 2004-11-18 - Publisher: "O'Reilly Media, Inc."

The Oracle SQLPlus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus.
Oracle SQL*Plus: The Definitive Guide
Language: en
Pages: 584
Authors: Jonathan Gennick
Categories: Computers
Type: BOOK - Published: 2004-11-16 - Publisher: "O'Reilly Media, Inc."

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQLPlus. This bestselling book--now updated for Oracle 1
Oracle Application Server 10g Essentials
Language: en
Pages: 262
Authors: Rick Greenwald
Categories: Computers
Type: BOOK - Published: 2004 - Publisher: "O'Reilly Media, Inc."

The new Oracle Application Server offers a wide range of functionality, including Java runtime and development tools, portal development tools, business intelli
Toad Pocket Reference for Oracle
Language: en
Pages: 122
Authors: Jeff Smith
Categories: Computers
Type: BOOK - Published: 2005-06-07 - Publisher: "O'Reilly Media, Inc."

Toad is an enormously popular interactive environment tool for Oracle development and administration. It allows developers to build, test, debug, and format the
SQL Tuning
Language: en
Pages: 338
Authors: Dan Tow
Categories: Computers
Type: BOOK - Published: 2003-11-19 - Publisher: "O'Reilly Media, Inc."

A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same networ
Oracle SQL*Plus
Language: en
Pages: 113
Authors: Jonathan Gennick
Categories: Computers
Type: BOOK - Published: 2002 - Publisher: "O'Reilly Media, Inc."

Discusses the command line SQL and PL/SQL language interface and reporting tool, providing information about its syntax and format elements.
TOAD Pocket Reference for Oracle
Language: en
Pages: 120
Authors: Jim McDaniel
Categories: Computers
Type: BOOK - Published: 2002 - Publisher: "O'Reilly Media, Inc."

Explores the interactive environment used for Oracle development and administration, covering topics including features, menus, defaults, shortcut keys, and SQL
Oracle in a Nutshell
Language: en
Pages: 906
Authors: Rick Greenwald
Categories: Computers
Type: BOOK - Published: 2003 - Publisher: "O'Reilly Media, Inc."

Oracle Languages - Syntax summary for SQL language statements, SQL function calls PL/SQL language statements and characteristics, PL/SQL built-in package header