Oracle SQL High-Performance Tuning by Guy Harrison

  •
1 1

Oracle SQL High-Performance Tuning by Guy Harrison

Checking stock...
Checking stock...
Zusammenfassung

Optimizing SQL code is the #1 factor in improving Oracle database performance, yet most guides to Oracle tuning virtually ignore SQL. This text zeroes in on SQL, showing how to achieve performance gains in many applications. Expert

The feel-good place to buy books
  • Free delivery in the UK
  • Supporting authors with AuthorSHARE
  • 100% recyclable packaging
  • B Corp - kinder to people and planet
  • Buy-back with World of Books - Sell Your Books

Oracle SQL High-Performance Tuning by Guy Harrison

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.

You might also like

GUY HARRISON has worked with Oracle databases for more than a decade, has conducted many Oracle training seminars, and is author of several books on Oracle, including Oracle Desk Reference (Prentice Hall PTR). Currently a product architect at Quest Software, Harrison has conducted many Oracle training seminars and has authored several articles for the Oracle Technical Journal. He resides in Australia.

SKU Nicht verfügbar
ISBN 13 9780130123817
ISBN 10 0130123811
Titel Oracle SQL High-Performance Tuning
Autor Guy Harrison
Buchzustand Nicht verfügbar
Bindungsart Paperback
Verlag Pearson Education (US)
Erscheinungsjahr 2001-01-09
Seitenanzahl 656
Hinweis auf dem Einband Die Abbildung des Buches dient nur Illustrationszwecken, die tatsächliche Bindung, das Cover und die Auflage können sich davon unterscheiden.
Hinweis Nicht verfügbar