Oracle SQL Tuning Pocket Reference (Paperback)
Oracle SQL Tuning Pocket Reference (Paperback)
Hero image 0 of Oracle SQL Tuning Pocket Reference (Paperback), 0 of 1

Oracle SQL Tuning Pocket Reference (Paperback)

(No ratings yet)

Key item features

Oracle SQL Tuning Pocket Reference (Paperback)

Specs

Publication date, February, 2002Author, Mark GurryBook format, PaperbackGenre, Computing & InternetPages, 108Age group, Adult

About this item

Product details

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.

Oracle SQL Tuning Pocket Reference (Paperback)
info:
We aim to show you accurate product information. Manufacturers, suppliers and others provide what you see here, and we have not verified it.  

Specifications

Publication date

February, 2002

Author

Mark Gurry

Book format

Paperback

Genre

Computing & Internet

Warranty

Warranty information

Please be aware that the warranty terms on items offered for sale by third party Marketplace sellers may differ from those displayed in this section (if any). To confirm warranty terms on an item offered for sale by a third party Marketplace seller, please use the 'Contact seller' feature on the third party Marketplace seller's information page and request the item's warranty terms prior to purchase.

Customer ratings & reviews

0 out of 5 stars
0 ratings|0 reviews
This item does not have any reviews yet
Current price is $8.03
Price when purchased online
  • Free 90-day returns

How do you want your item?

Try 30 days for just $1! Choose a plan at checkout.
How do you want your item?
Ships to
Arrives by Sat, Nov 21
Sold and shipped by Walmart.com
Free 90-day returns
This item is gift eligible
Other sellers
$11.43
+Free shipping
Shipping, arrives by Fri, Nov 20 to Columbus, 43215
Sold and shipped by Alibris Books
Free Holiday returns until Jan 31
walmart plus

Try 30 days of Walmart+ for just $1!

T&C apply.