Your Waterstones card is changing, introducing...
TELL ME MORE
Oracle SQL High-Performance Tuning (Paperback)
  • Oracle SQL High-Performance Tuning (Paperback)
zoom

Oracle SQL High-Performance Tuning (Paperback)

(author)
£40.99
Paperback 656 Pages / Published: 09/01/2001
  • We can order this

Usually despatched within 3 weeks

  • This item has been added to your basket

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.

Publisher: Pearson Education (US)
ISBN: 9780130123817
Number of pages: 656
Weight: 1039 g
Dimensions: 178 x 178 x 44 mm
Edition: 2nd edition

You may also be interested in...

MySQL Cookbook
Added to basket
£63.99
Paperback
Access 2013 Bible
Added to basket
T-SQL Querying
Added to basket
£43.99
Paperback
Access 2013 All-in-One For Dummies
Added to basket
Oracle PL/SQL Programming
Added to basket
Big Data For Dummies
Added to basket
Microsoft Access 2010 Step by Step
Added to basket
Microsoft Access 2013 Plain & Simple
Added to basket
Pro SQL Server 2012 BI Solutions
Added to basket
MySQL
Added to basket
£40.99
Paperback
Microsoft SQL Server 2012 Step by Step
Added to basket
PHP and MySQL Web Development
Added to basket

Reviews

Please sign in to write a review

Your review has been submitted successfully.