Osoby które kupowały "Oracle SQL Tuning Pocket Reference", wybierały także:

• PL/SQL. Kurs video. Od podstaw do zagadnieÅ„ zaawansowanych. Programowanie baz danych 79,00 zÅ‚, (31,60 zÅ‚ -60%)
• Linux Server. Kurs video. UsÅ‚ugi serwerowe, skrypty i Å›rodowisko graficzne 69,00 zÅ‚, (34,50 zÅ‚ -50%)
• Tablice informatyczne. SQL. Wydanie III 16,98 zÅ‚, (8,49 zÅ‚ -50%)
• SQL w 24 godziny. Wydanie VI 69,00 zÅ‚, (34,50 zÅ‚ -50%)
• Oracle PL/SQL w mgnieniu oka 44,90 zÅ‚, (22,45 zÅ‚ -50%)

Spis treści

Oracle SQL Tuning Pocket Reference eBook -- spis treści

• 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