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
17 used & new from £20.98
Have one to sell? Sell yours here
 
   
Tell a Friend
Oracle Sql High Performance Tuning (Prentice Hall PTR Oracle)
 
See larger image 
Share your own customer images
Publisher: learn how customers can search inside this book.
Oracle Sql High Performance Tuning (Prentice Hall PTR Oracle) (Paperback)
by Guy Harrison (Author)
4.0 out of 5 stars  (5 customer reviews)
RRP: £39.99
Price: £35.99 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £4.00 (10%)
Availability: Usually dispatched within 10 to 14 days. Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

17 used & new available from £20.98
Other Editions: RRP: Our Price: Other Offers:
Paperback (Pap/Cdr) 10 used & new from £13.60
 
   

Frequently Bought Together

Customers buy this book with Expert Oracle Database Architecture - 9i and 10g Programming Techniques and Solutions by Thomas Kyte

Oracle Sql High Performance Tuning (Prentice Hall PTR Oracle) Expert Oracle Database Architecture - 9i and 10g Programming Techniques and Solutions
Price For Both: £69.98

Customers Who Bought This Item Also Bought

Expert Oracle Database Architecture - 9i and 10g Programming Techniques and Solutions

Expert Oracle Database Architecture - 9i and 10g Programming Techniques and Solutions by Thomas Kyte

4.3 out of 5 stars (3)  £33.99
Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle)

Cost-Based Oracle Fundamentals: v. 1 (Expert's Voice in Oracle) by Jonathan Lewis

4.8 out of 5 stars (10)  £33.99
› Explore similar items : Books (2)

Product details

  • Paperback: 656 pages
  • Publisher: Prentice Hall; 2 edition (9 Jan 2001)
  • Language English
  • ISBN-10: 0130123811
  • ISBN-13: 978-0130123817
  • Product Dimensions: 23 x 17.6 x 3.6 cm
  • Average Customer Review: 4.0 out of 5 stars  (5 customer reviews)
  • Amazon.co.uk Sales Rank: 184,310 in Books (See Bestsellers in Books)

    Popular in this category:

    #23 in  Books > Computing & Internet > Databases > Oracle > PL & SQL

    (Publishers and authors: Improve Your Sales)
  • Other Editions: Paperback (Pap/Cdr) |  All Editions

    •  Would you like to update product info or give feedback on images?

  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

 (What is this?)
Oracle Performance Issues
www.teamsolve.co.uk/performance    Expert Oracle Consultants - Improve your Oracle systems 
Accenture Performance
www.Accenture.com    Read Accenture's Ground Breaking High Performance Business Research. 
Oracle Sql Performance
www.Confio.com    Optimize Oracle SQL with Ignite Powerful Results. Free Download. 

Product Description

Product Description

Optimizing SQL code is the #1 factor in improving Oracle database performance, yet most guides to Oracle tuning virtually ignore SQL. Oracle SQL High Performance Tuning, Second Edition zeroes in on SQL, showing how to achieve performance gains of 100% in many applications. Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8i SQL and PL/SQL tuning. Harrison begins with a detailed overview of SQL processing in Oracle, and then introduces SQL tuning guidelines that improve virtually any application. Learn how to trace SQL statement execution, create more effective indexes, identify and resolve Oracle Server bottlenecks, and fix poorly performing SQL code. Master Oracle tuning tools such as tkprof and explain; leverage Oracle's parallel query facility for large-volume queries; and maximize the performance of Oracle clusters. The book outlines up-front design techniques for enhancing application efficiency; includes detailed real-world tuning guidelines for both SQL and PL/SQL; and presents opportunities to improve performance by substituting PL/SQL or Java for SQL.



Synopsis
Optimizing SQL code is the #1 factor in improving Oracle database performance, yet most guides to Oracle tuning virtually ignore SQL. Oracle SQL High Performance Tuning, Second Edition zeroes in on SQL, showing how to achieve performance gains of 100% in many applications. Expert Oracle developer Guy Harrison gives Oracle developers and DBAs a single source for guidance on every aspect of Oracle 8i SQL and PL/SQL tuning. Harrison begins with a detailed overview of SQL processing in Oracle, and then introduces SQL tuning guidelines that improve virtually any application. Learn how to trace SQL statement execution, create more effective indexes, identify and resolve Oracle Server bottlenecks, and fix poorly performing SQL code. Master Oracle tuning tools such as tkprof and explain; leverage Oracle's parallel query facility for large-volume queries; and maximize the performance of Oracle clusters. The book outlines up-front design techniques for enhancing application efficiency; includes detailed real-world tuning guidelines for both SQL and PL/SQL; and presents opportunities to improve performance by substituting PL/SQL or Java for SQL.

See all Product Description