Oracle High-Performance SQL Tuning - Brossura

Libro 8 di 135: Oracle Press

BURLESON

 
9780072190588: Oracle High-Performance SQL Tuning
Brossura
ISBN 10: 0072190582 ISBN 13: 9780072190588
Casa editrice: McGraw Hill, 2001

Sinossi

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


From the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal execution

This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Informazioni sull?autore

Don Burleson (Kittrell, NC) has 20 years of experience as a database administrator and has written 9 books on database management including Oracle SAP Administration (O’Reilly), High-Performance Oracle8 Tuning, High-Performance Oracle Data Warehousing, High-Performance Oracle Database Applications (Coriolis) and Oracle8 Tuning, German Edition (Sybex). Don has taught more than 100 University courses and regularly conducts in-house Oracle training.

Dalla quarta di copertina

Improve Database Performance by Tuning SQL Statements

Tune all types of SQL statements--from a simple SELECT statement to a complex non-correlated subquery--using tips and techniques from SQL expert Don Burleson. Officially authorized by Oracle Corporation, this in-depth resource explains how to take any SQL statement, view the internal execution plan, and change the execution plan to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.

  • Understand how SQL tuning fits into the overall Oracle tuning model
  • Improve Oracle SQL functionality using extensions such as in-line views and BIFs
  • Identify and report on SQL in the library cache
  • Tune SQL table access, full-table scans, and parallel query
  • Run TKPROF to get a SQL trace report
  • Change the execution plans for Oracle SQL statements using Oracle hints
  • Use the Oracle8i optimizer plan stability, cost-based optimizer, and rule-based optimizer
  • Tune SQL DML statements, SQL subqueries, and data warehouse SQL
  • Tune SQL with temporary tables and indexes
  • Diagnose and optimize system performance using STATSPACK

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Editore
McGraw Hill
Data di pubblicazione
2001
Lingua
Inglese
ISBN 10 
0072190582
ISBN 13 
9780072190588
Rilegatura
Copertina flessibile
Numero di pagine
605
Contatto del produttore
Messaggerie Libri
ufficio.anagrafiche@meli.it

Via Verdi, 8.
Assago Milano
20090
Italia