Articoli correlati a Oracle SQL High-Performance Tuning
Sinossi
A guide to using Oracle's parallel query facility for large volume queries focusing on SQL and PL/SQL. Harrison, an Oracle developer and consultant, overviews SQL processing and introduces guidelines to improve applications, including execution plans, work with joins, nulls and ranges search, index building, hierarchical queries, table scans, GROUP BY, updates, and distributed SQL. The accompanying CD-ROM features a set of tools for detecting and correcting SQL bottlenecks. Annotation c. by Book News, Inc., Portland, Or.
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
Dalla quarta di copertina
61423-0
The complete developer's guide to optimizing Oracle SQL code.
Optimizing SQL code is the #1 factor in improving Oracle database performance. Yet most guides to Oracle tuning virtually ignore SQL. Until now. Oracle SQL High-Performance Tuning zeroes in on SQL, showing how to achieve performance gains of 100% or more in many applications.
Expert Oracle developer Guy Harrison presents a detailed overview of SQL processing, and then introduces SQL tuning guidelines that improve virtually any application. Learn how to:
- Choose execution plans.
- Work with joins.
- Search for nulls and ranges.
- Trace SQL statement execution.
- Build indexes that support efficient queries.
- Optimize virtually all type of SQL including: views, hierarchical queries, table scans, GROUP BY, updates, subqueries, distributed SQL, and more.
As databases grow, and ad hoc queries to data warehouses increase, optimizing SQL becomes even more critical. Harrison offers practical guidance on using Oracle's parallel query facility for large-volume queries, and shows when to use Oracle's PL/SQL instead of standard SQL.
The book is replete with examples, showing poorly tuned SQL, how to fix it—and specific performance measurements collected on a wide range of computer hardware, from high-end UNIX SMP hosts to 486 laptops running Personal Oracle.
The CD-ROM contains an extraordinary collection of Oracle SQL tuning tools, including:
- A complete freeware Tuning Toolkit for generating SQL execution plans in a Windows environment, and for monitoring server load and efficiency.
- Trial versions of the SQLab tuning environment, Precise/SQL tuning tools, and SQL Navigator development environment.
- Full-function 90-day trial versions of Personal Oracle for Windows 3.1 and Windows 95.
If your Oracle applications must deliver supercharged performance, you can't afford to be without Guy Harrison's Oracle SQL High-Performance Tuning.
Product Description
Book by Harrison Guy
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
- EditorePrentice Hall Ptr
- Data di pubblicazione1997
- ISBN 10 0136142311
- ISBN 13 9780136142317
- RilegaturaCopertina flessibile
- LinguaInglese
- Numero di pagine491
Risultati della ricerca per Oracle SQL High-Performance Tuning
Foto dell'editore
Oracle SQL : High-Performance Tuning
Da: Better World Books, Mishawaka, IN, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: Good. Pap/Cdr. Used book that is in clean, average condition without any missing pages. Codice articolo 289666-75
Quantità: 1 disponibili
Foto dell'editore
Oracle SQL: High Performance Tuning
Da: BookHolders, Towson, MD, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: Good. [ No Hassle 30 Day Returns ][ Ships Daily ] [ Underlining/Highlighting: NONE ] [ Writing: NONE ] [ Edition: reprint ] [ 1 CD/Disk(s) Included ] Publisher: Prentice Hall Ptr Pub Date: 1/15/1997 Binding: paperback Pages: 496 reprint edition. Codice articolo 6653340
Quantità: 1 disponibili
Foto dell'editore
Oracle SQL High-Performance Tuning with CDROM
Da: Wonder Book, Frederick, MD, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: Good. Good condition. A copy that has been read but remains intact. May contain markings such as bookplates, stamps, limited notes and highlighting, or a few light stains. Bundled media such as CDs, DVDs, floppy disks or access codes may not be included. Codice articolo P10J-02051
Quantità: 1 disponibili
Foto dell'editore
Oracle SQL High-Performance Tuning
Editore:
Prentice Hall Ptr, 1997
ISBN 10: 0136142311
ISBN 13: 9780136142317
Antico o usato
paperback
Da: HPB-Red, Dallas, TX, U.S.A.
Valutazione del venditore 5 su 5 stelle
paperback. Condizione: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Codice articolo S_389158756
Quantità: 1 disponibili
Immagini fornite dal venditore
Oracle SQL High-Performance Tuning
Da: NEPO UG, Rüsselsheim am Main, Germania
Valutazione del venditore 5 su 5 stelle
Condizione: Sehr gut. Auflage: Pap/Cdr. 491 Seiten ex library book - Sprache: Englisch Gewicht in Gramm: 969 23,2 x 17,8 x 3,6 cm, Taschenbuch. Codice articolo 344612
Quantità: 1 disponibili