Oracle SQL Tuning Pocket Reference

(ebook) (audiobook) (audiobook)

Autor:: Mark Gurry

Promocja Przejdź

Oracle SQL Tuning Pocket Reference Mark Gurry - okladka książki

Oracle SQL Tuning Pocket Reference Mark Gurry - audiobook MP3

Oracle SQL Tuning Pocket Reference Mark Gurry - audiobook CD

Wydawnictwo:: O'Reilly Media (Z chęcią przeczytam książkę w języku polskim)
Ocena:: Bądź pierwszym, który oceni tę książkę
Stron:: 110
Dostępne formaty:: ePub

Mobi

Ebook (29,67 zł najniższa cena z 30 dni)

~~34,90 zł~~ (-15%)
29,67 zł

Dodaj do koszyka lub Kup na prezent Kup 1-kliknięciem

(29,67 zł najniższa cena z 30 dni)

Przenieś na półkę

Do przechowalni

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.

Wybrane bestsellery

Ebooka "Oracle SQL Tuning Pocket Reference" przeczytasz na:

czytnikach Inkbook, Kindle, Pocketbook, Onyx Booxs i innych
systemach Windows, MacOS i innych

systemach Windows, Android, iOS, HarmonyOS
na dowolnych urządzeniach i aplikacjach obsługujących formaty: PDF, EPub, Mobi

Masz pytania? Zajrzyj do zakładki Pomoc »

Audiobooka "Oracle SQL Tuning Pocket Reference" posłuchasz:

w aplikacji Ebookpoint na Android, iOS, HarmonyOs
na systemach Windows, MacOS i innych

na dowolonych urządzeniach
i aplikacjach obsługujących format MP3
(pliki spakowane w ZIP)

Masz pytania? Zajrzyj do zakładki Pomoc »

Kurs Video "Oracle SQL Tuning Pocket Reference" zobaczysz:

Oceny i opinie klientów: Oracle SQL Tuning Pocket Reference Mark Gurry (0) Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.

Szczegóły książki

ISBN Ebooka:: 978-05-965-5213-8, 9780596552138
Data wydania ebooka :: 2002-01-01 Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie. Jeśli masz wątpliwości skontaktuj się z nami sklep@helion.pl.
Język publikacji:: angielski
Rozmiar pliku ePub:: 590.8kB
Rozmiar pliku Mobi:: 1.4MB

Zgłoś erratę
Kategorie:
Bazy danych » Oracle - Programowanie

Spis treści książki

Oracle SQL Tuning Pocket Reference
- SPECIAL OFFER: Upgrade this ebook with OReilly
- 1. Oracle SQL TuningPocket Reference
  - 1.1. Introduction
    - 1.1.1. Acknowledgments
    - 1.1.2. Caveats
    - 1.1.3. Conventions
    - 1.1.4. Whats New in Oracle9i
  - 1.2. The SQL Optimizers
    - 1.2.1. Understanding the Rule-Based Optimizer
      - 1.2.1.1. What the RBO rules don't tell you #1
      - 1.2.1.2. What the RBO rules don't tell you #2
      - 1.2.1.3. What the RBO rules don't tell you #3
      - 1.2.1.4. What the RBO rules don't tell you #4
      - 1.2.1.5. What the RBO rules don't tell you #5
      - 1.2.1.6. What the RBO rules don't tell you #6
      - 1.2.1.7. What the RBO rules don't tell you #7
    - 1.2.2. Understanding the Cost-Based Optimizer
      - 1.2.2.1. ANALYZE command
      - 1.2.2.2. Tuning prior to releasing to production
      - 1.2.2.3. Inner workings of the cost-based optimizer
      - 1.2.2.4. EXPLAIN PLAN for the cost-based optimizer
    - 1.2.3. Some Common Optimizer Misconceptions
    - 1.2.4. Which Optimizer to Use?
  - 1.3. Rule-Based Optimizer Problems and Solutions
    - 1.3.1. Problem 1: Incorrect Driving Table
    - 1.3.2. Problem 2: Incorrect Index
    - 1.3.3. Problem 3: Incorrect Driving Index
    - 1.3.4. Problem 4: Using the ORDER BY Indexand not the WHERE Index
  - 1.4. Cost-Based Optimizer Problems and Solutions
    - 1.4.1. Problem 1: The Skewness Problem
    - 1.4.2. Problem 2: Analyzing with Wrong Data
      - 1.4.2.1. How to check the last analyzed date
      - 1.4.2.2. When to analyze
    - 1.4.3. Problem 3: Mixing the Optimizers in Joins
    - 1.4.4. Problem 4: Choosing an Inferior Index
    - 1.4.5. Problem 5: Joining Too Many Tables
    - 1.4.6. Problem 6: Incorrect INIT.ORA Parameter Settings
  - 1.5. Problems Common to Rule and Cost with Solutions
    - 1.5.1. Problem 1: Statement Not Written for Indexes
    - 1.5.2. Problem 2: Indexes Are Missing or Inappropriate
      - 1.5.2.1. Indexing versus full table scans
      - 1.5.2.2. Adding columns to indexes
      - 1.5.2.3. Should I index small tables?
    - 1.5.3. Problem 3: Use of Single-Column Index Merge
    - 1.5.4. Problem 4: Misuse of Nested Loop, Sort Merge, or Hash Join
    - 1.5.5. Problem 5: Misuse of IN, EXISTS, NOT IN, NOT EXISTS, or Table Joins
      - 1.5.5.1. When a join outperforms a subquery
      - 1.5.5.2. Which is faster, IN or EXISTS?
    - 1.5.6. Problem 6: Unnecessary Sorts
      - 1.5.6.1. Consider UNION ALL in place of UNION
      - 1.5.6.2. Consider using an index to avoid a sort
    - 1.5.7. Problem 7: Too Many Indexes on a Table
    - 1.5.8. Problem 8: Use of OR Instead of UNION
    - 1.5.9. Problem 9: Tables and Indexes with Many Deletes
    - 1.5.10. Other Problems: Heavy Usage of Views
    - 1.5.11. Other Problems: Joining Too Many Tables
  - 1.6. Handy SQL Tuning Tips
    - 1.6.1. Identify Bad SQL
    - 1.6.2. Identify Long-Running SQL Statements
    - 1.6.3. Use DECODE for IF/ELSE Selection
    - 1.6.4. Encourage Bind Variables
  - 1.7. Using SQL Hints
    - 1.7.1. When Are Hints Ignored?
    - 1.7.2. Using Hints in Views
    - 1.7.3. Available Hints
  - 1.8. Using DBMS_STATS to Manage Statistics
    - 1.8.1. Using DBMS_STATS to Analyze Faster
    - 1.8.2. Copying Statistics Using DBMS_STATS
    - 1.8.3. Manipulating Statistics Using DBMS_STATS
    - 1.8.4. Reverting to Previous Statistics
  - 1.9. Using Outlines for Consistent Execution Plans
    - 1.9.1. Recording Outlines
      - 1.9.1.1. Recording an outline for a SQL statement
      - 1.9.1.2. Recording outlines for all of a session's SQL
      - 1.9.1.3. Recording outlines for the whole system
    - 1.9.2. Enabling Outlines
      - 1.9.2.1. Enabling outlines for a session
      - 1.9.2.2. Enabling outlines for the whole system
    - 1.9.3. Managing Outlines
      - 1.9.3.1. Viewing your outlines
      - 1.9.3.2. Transferring outlines between databases
      - 1.9.3.3. Dealing with literals
- Index
- About the Author
- SPECIAL OFFER: Upgrade this ebook with OReilly