Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
31 used & new from £1.10

Have one to sell? Sell yours here
 
   
Oracle SQL Tuning Pocket Reference
 
 

Oracle SQL Tuning Pocket Reference (Paperback)

by Mark Gurry (Author)
3.5 out of 5 stars See all reviews (2 customer reviews)
RRP: £7.50
Price: £5.63 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £1.87 (25%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 5 left in stock--order soon (more on the way).

Want guaranteed delivery by Tuesday, July 21? Choose Express delivery at checkout. See Details
23 new from £2.49 8 used from £1.10

Frequently Bought Together

Oracle SQL Tuning Pocket Reference + Oracle PL/SQL Language Pocket Reference (Pocket Reference (O'Reilly)) + Oracle DBA Pocket Guide (Pocket Reference)
Price For All Three: £18.74

Show availability and shipping details


Customers Who Bought This Item Also Bought

Oracle PL/SQL Language Pocket Reference (Pocket Reference (O'Reilly))

Oracle PL/SQL Language Pocket Reference (Pocket Reference (O'Reilly))

by Steven Feuerstein
4.2 out of 5 stars (4)  £7.48
Oracle DBA Pocket Guide (Pocket Reference)

Oracle DBA Pocket Guide (Pocket Reference)

by David Kreines
£5.63
Oracle PL/SQL Best Practices

Oracle PL/SQL Best Practices

by Steven Feuerstein
4.3 out of 5 stars (3)  £14.94
Oracle PL/SQL Programming

Oracle PL/SQL Programming

by Steven Feuerstein
4.3 out of 5 stars (20)  £32.49
Oracle Data Dictionary Pocket Reference (Pocket Referemce)

Oracle Data Dictionary Pocket Reference (Pocket Referemce)

by David Kreines
5.0 out of 5 stars (1)  £5.63
Explore similar items

Product details

  • Paperback: 112 pages
  • Publisher: O'Reilly Media, Inc. (13 April 2004)
  • Language English
  • ISBN-10: 0596002688
  • ISBN-13: 978-0596002688
  • Product Dimensions: 17.2 x 10.8 x 0.8 cm
  • Average Customer Review: 3.5 out of 5 stars See all reviews (2 customer reviews)
  • Amazon.co.uk Sales Rank: 187,731 in Books (See Bestsellers in Books)

    Popular in these categories:

    #14 in  Books > Computing & Internet > Databases > Oracle > PL & SQL
    #25 in  Books > Computing & Internet > Certification > Subjects > Oracle
    #98 in  Books > Computing & Internet > Databases > Database Theory
  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
SQL Server Tuning
   www.Confio.com    Improve SQL Server Performance 65%, Save on Costs, Free Trial Download! 
SQL tuning tool
   www.sqlpower.com    Identify SQL bottlenecks in seconds Tune your worst performing SQL 
My SQL Experts for Hire
   www.percona.com    Pay-as-you-go Services for My SQL Support, Consulting, Remote DBA 
  
 

Product Description

Product Description
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. He 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, the book provides a number of SQL tuning tips. It discusses the various optimizer hints, telling you when they can be used to good effect. Finally, it 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..

From the Publisher
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. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. Mark provides a number of handy SQL tuning tips, discusses the use of the DBMS_STATS package to manage database statistics, and shows you how to use outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.

See all Product Description

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Back Cover
Search inside this book:

Suggested Tags from Similar Products

 (What's this?)
Be the first one to add a relevant tag (keyword that's strongly related to this product)
Check a corresponding box or enter your own tags in the field below
oracle
sql
pocket reference - oreilly
oracle sql plsql oreilly optimization tu...
computer science
computer

Your tags: Add your first tag
 

What Do Customers Ultimately Buy After Viewing This Item?

Oracle SQL Tuning Pocket Reference
68% buy the item featured on this page:
Oracle SQL Tuning Pocket Reference 3.5 out of 5 stars (2)
£5.63
Oracle PL/SQL Language Pocket Reference (Pocket Reference (O'Reilly))
13% buy
Oracle PL/SQL Language Pocket Reference (Pocket Reference (O'Reilly)) 4.2 out of 5 stars (4)
£7.48
Mastering Oracle SQL
6% buy
Mastering Oracle SQL 3.7 out of 5 stars (3)
£20.14
Oracle PL/SQL Programming
6% buy
Oracle PL/SQL Programming 4.3 out of 5 stars (20)
£32.49

 

Customer Reviews

2 Reviews
5 star:
 (1)
4 star:    (0)
3 star:    (0)
2 star:
 (1)
1 star:    (0)
 
 
 
 
 
Average Customer Review
3.5 out of 5 stars (2 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
15 of 19 people found the following review helpful:
5.0 out of 5 stars I love these books...., 4 Feb 2002
By A Customer
Easy to read and 'dip' into, plain english, get's to the point, lot's of examples, thin (I hate reading books) and covers the most important aspects of SQL tuning ie. hints.
It's the kind of thing you read/reference for a few months and then chuck away because you actually LEARN from these kind of books...
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
2.0 out of 5 stars Good but now out of date, 22 Feb 2009
By S. Basak "sbasak" - See all my reviews
(REAL NAME)   
This book was written for Oracle 9i. It talks a great amount about Rule Based Optimizer. There are some good tuning tips but they are mostly common. If you are working with Oracle 10-11g, then this book won't offer any benefit. Most of what it says here, can be available by just internet search.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   


Listmania!


Look for similar items by category


Feedback


Fun for Everyone

Christmas Gifts
Achieve over 15,000 RPM with our great range of Powerballs.

Shop the Powerball store

 

More From Mark Gurry

Oracle Performance Tuning

Oracle Performance Tuning by Mark Gurry

The books in O'Reilly's Oracle series are authoritative -- they tell... Read more

 

Train Hard...Play Hard

Nike, Gola, Converse, and more
Gear up with up to 60% off athletic and outdoor shoes.

Shop now

 

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

Learn more about Gift Certificates

 
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue Shopping: Top Sellers

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates