Name: Oracle sql Tuning Pocket Reference: Write Efficient sql
Price: 218.00 ZAR
Availability: InStock
Author: Mark Gurry
ISBN: 9780596002688

portada Oracle sql Tuning Pocket Reference: Write Efficient sql

Oracle sql Tuning Pocket Reference: Write Efficient sql

Type

Physical Book

Author

Mark Gurry

Publisher

O'reilly & Associates

Year

2002

Language

English

Pages

110

Format

Paperback

Dimensions

17.3 x 10.7 x 0.8 cm

Weight

0.07 kg.

ISBN

0596002688

ISBN13

9780596002688

Edition No.

Synopsis "Oracle sql Tuning Pocket Reference: Write Efficient sql"

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.

Customers reviews

Have you read this book? Login to add your review.

More customer reviews

0% (0)
0% (0)
0% (0)
0% (0)
0% (0)

Questions and Answers about the Book

Do you have a question about the book? Login to be able to add your own question.

Opinions about Bookdelivery

More customer reviews

Oracle sql Tuning Pocket Reference: Write Efficient sql - Mark Gurry

Synopsis "Oracle sql Tuning Pocket Reference: Write Efficient sql"

Customers reviews

Frequently Asked Questions about the Book

Is the book original?

In what language is the book written?

What is the format of this book?

Questions and Answers about the Book

Opinions about Bookdelivery