Oracle SQL Tuning Pocket Reference

3,41 valoración promedio
( 17 valoraciones por GoodReads )
 
9780596002688: Oracle SQL Tuning Pocket Reference
From the Publisher:

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner.

In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. Mark also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers.

In addition to the specific problem/solution scenarios for the optimizers, Mark provides a number of handy SQL tuning tips. He discusses the various optimizer hints, telling you when they can be used to good effect. Finally, Mark discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.

From the Publisher:

In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. He also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problem/solution scenarios for the optimizers, the book provides a number of SQL tuning tips. It discusses the various optimizer hints, telling you when they can be used to good effect. Finally, it discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify..

"Sobre este título" puede pertenecer a otra edición de este libro.

Los mejores resultados en AbeBooks

1.

Mark Gurry
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Cantidad: > 20
Impresión bajo demanda
Librería
BargainBookStores
(Grand Rapids, MI, Estados Unidos de America)
Valoración
[?]

Descripción Paperback. Estado de conservación: New. This item is printed on demand. Item doesn't include CD/DVD. Nº de ref. de la librería 1185102

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 4,65
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,73
A Estados Unidos de America
Destinos, gastos y plazos de envío

2.

Mark Gurry
Editorial: O Reilly Media, Inc, USA, United States (2002)
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Cantidad: 1
Librería
The Book Depository US
(London, Reino Unido)
Valoración
[?]

Descripción O Reilly Media, Inc, USA, United States, 2002. Paperback. Estado de conservación: New. 172 x 108 mm. Language: English . Brand New Book. In this book, Mark Gurry shares his in-depth knowledge of Oracle s SQL statement optimizers. Mark s knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. He also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problem/solution scenarios for the optimizers, the book provides a number of SQL tuning tips. It discusses the various optimizer hints, telling you when they can be used to good effect. Finally, it discusses the use of the DBMS STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can t otherwise modify. Nº de ref. de la librería AAH9780596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 8,48
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

3.

Mark Gurry
Editorial: O'Reilly Media
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos PAPERBACK Cantidad: > 20
Librería
Mediaoutlet12345
(Springfield, VA, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media. PAPERBACK. Estado de conservación: New. 0596002688 *BRAND NEW* Ships Same Day or Next!. Nº de ref. de la librería SWATI2122333896

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 4,98
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,73
A Estados Unidos de America
Destinos, gastos y plazos de envío

4.

Mark Gurry
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Cantidad: 1
Librería
Grand Eagle Retail
(Wilmington, DE, Estados Unidos de America)
Valoración
[?]

Descripción 2004. Paperback. Estado de conservación: New. 110mm x 10mm x 178mm. Paperback. One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL sta.Shipping may be from multiple locations in the US or from the UK, depending on stock availability. 108 pages. 0.104. Nº de ref. de la librería 9780596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 8,81
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

5.

Mark Gurry
Editorial: O Reilly Media, Inc, USA, United States (2002)
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Cantidad: 1
Librería
The Book Depository
(London, Reino Unido)
Valoración
[?]

Descripción O Reilly Media, Inc, USA, United States, 2002. Paperback. Estado de conservación: New. 172 x 108 mm. Language: English . Brand New Book. In this book, Mark Gurry shares his in-depth knowledge of Oracle s SQL statement optimizers. Mark s knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. He also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problem/solution scenarios for the optimizers, the book provides a number of SQL tuning tips. It discusses the various optimizer hints, telling you when they can be used to good effect. Finally, it discusses the use of the DBMS STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can t otherwise modify. Nº de ref. de la librería AAH9780596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 9,68
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

6.

Mark Gurry
Editorial: O'Reilly Media 2002-01-08 (2002)
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Cantidad: 5
Librería
Chiron Media
(Wallingford, Reino Unido)
Valoración
[?]

Descripción O'Reilly Media 2002-01-08, 2002. Estado de conservación: New. Brand new book, sourced directly from publisher. Dispatch time is 24-48 hours from our warehouse. Book will be sent in robust, secure packaging to ensure it reaches you securely. Nº de ref. de la librería NU-ING-00318265

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 6,73
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,49
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

7.

Mark Gurry
Editorial: O'Reilly Media
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Cantidad: 20
Librería
BuySomeBooks
(Las Vegas, NV, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media. Paperback. Estado de conservación: New. Paperback. 112 pages. Dimensions: 6.8in. x 4.2in. x 0.3in.One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner. In this book, Mark Gurry shares his in-depth knowledge of Oracles SQL statement optimizers. Marks knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. Mark also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problemsolution scenarios for the optimizers, Mark provides a number of handy SQL tuning tips. He discusses the various optimizer hints, telling you when they can be used to good effect. Finally, Mark discusses the use of the DBMSSTATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you cant otherwise modify. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Nº de ref. de la librería 9780596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 8,02
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,69
A Estados Unidos de America
Destinos, gastos y plazos de envío

8.

Mark Gurry
Editorial: O'Reilly Media (2002)
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Tapa blanda Cantidad: 1
Librería
Book Deals
(Lewiston, NY, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2002. Estado de conservación: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: Introduction The SQL Optimizers Understanding the Rule-Based Optimizer Understanding the Cost-Based Optimizer Some Common Optimizer Misconceptions Which Optimizer to Use? Rule-Based Optimizer Problems and Solutions Problem 1: Incorrect Driving Table Problem 2: Incorrect Index Problem 3: Incorrect Driving Index Problem 4: Using the ORDER BY Index and notthe WHERE Index Cost-Based Optimizer Problems and Solutions Problem 1: The Skewness Problem Problem 2: Analyzing with Wrong Data Problem 3: Mixing the Optimizers in Joins Problem 4: Choosing an Inferior Index Problem 5: Joining Too Many Tables Problem 6: Incorrect INIT.ORA Parameter Settings Problems Common to Rule and Cost with Solutions Problem 1: Statement Not Written for Indexes Problem 2: Indexes Are Missing or Inappropriate Problem 3: Use of Single-Column Index Merge Problem 4: Misuse of Nested Loop, Sort Merge,or Hash Join Problem 5: Misuse of IN, EXISTS, NOT IN, NOT EXISTS,or Table Joins Problem 6: Unnecessary Sorts Problem 7: Too Many Indexes on a Table Problem 8: Use of OR Instead of UNION Problem 9: Tables and Indexes with Many Deletes Other Problems: Heavy Usage of Views Other Problems: Joining Too Many Tables Handy SQL Tuning Tips Identify Bad SQL Identify Long-Running SQL Statements Use DECODE for IF/ELSE Selection Encourage Bind Variables Using SQL Hints When Are Hints Ignored? Using Hints in Views Available Hints Using DBMSSTATS to Manage Statistics Using DBMSSTATS to Analyze Faster Copying Statistics Using DBMSSTATS Manipulating Statistics Using DBMSSTATS Reverting to Previous Statistics Using Outlines for Consistent Execution Plans Recording Outlines Enabling Outlines Managing Outlines. Nº de ref. de la librería ABE_book_new_0596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 11,81
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

9.

Mark Gurry
Editorial: O'Reilly Media (2002)
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Cantidad: 10
Librería
Ergodebooks
(RICHMOND, TX, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2002. Paperback. Estado de conservación: New. Nº de ref. de la librería INGM9780596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 9,68
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,73
A Estados Unidos de America
Destinos, gastos y plazos de envío

10.

Mark Gurry
Editorial: O'Reilly Media (2001)
ISBN 10: 0596002688 ISBN 13: 9780596002688
Nuevos Paperback Primera edición Cantidad: 1
Librería
Ergodebooks
(RICHMOND, TX, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2001. Paperback. Estado de conservación: New. 1st. Nº de ref. de la librería DADAX0596002688

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 12,30
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,73
A Estados Unidos de America
Destinos, gastos y plazos de envío

Existen otras copia(s) de este libro

Ver todos los resultados de su búsqueda