Copyright Notice

  1. About this guide
    1. Where do I start?
  2. Isolating problem SQL
    1. SQL*Text
    2. Oracle Trace
    3. SQL*Trace
    4. Top SQL
    5. Database Trace
  3. Analysing problem SQL
    1. Quick Fixes
      1. No Statistics
      2. Bad Hints
      3. Cartesian Product
      4. Full Table Scan
      5. Multiple Table Joins
      6. Remote Table
      7. AND-EQUAL Trap
      8. Triggers
      9. Referential Integrity
      10. Locking Problems
    2. Data Storage Problems
      1. Chaining
      2. High Water Mark
      3. Fragmented Index
      4. Empty Hash Cluster
    3. Low Volume SQLs
      1. Index is Missing
      2. Not Using Index
      3. Index Range Scan
      4. Table Not Clustered
      5. Not Using Cluster
      6. Sub-query Blowout
      7. Inefficient Hash Cluster
    4. High Volume SQLs
      1. Index Scans
      2. Nested Loops and Filters
      3. Partition Prune
      4. Star Joins
      5. Self Joins
      6. Sorts
      7. Querying Views
      8. Index Join
      9. Sparse Join
    5. High Volume DML
      1. Direct Load Insert
      2. Create Table as Select
      3. Updateable Join Views
      4. Truncate and Replace
      5. Drop and Rebuild Indexes
      6. Rowid Range
    6. High Volume Procedural Code
      1. Concurrent Cursors
Appendicies
  1. Advanced Oracle Objects
  2. Explain Plan
  3. TK*Prof
  4. Hints
  5. Join Methods
  6. Problems and Fixes
    1. Missing Statistics
    2. Bad Hints
    3. Cartesian Joins
    4. Full Table Scan
    5. Multiple Table Joins
    6. Remote Table
    7. AND-EQUALS Trap
    8. Triggers
    9. Referential Integrity

    10. Chaining
    11. Volatile Tables
    12. Empty Hash Cluster

    13. Missing Index
    14. Function Based Indexes
    15. Comparison Operators
    16. Logical Operators
    17. Concatenated Indexes
    18. Querying Views
    19. Indexed Table Joins
    20. Bitmap Indexes
    21. Star Queries
    22. Casting
    23. Indexed Sub-Queries
    24. Index Skip Scan
    25. Index Range Scan
    26. Range Keyed Tables
    27. Sub-query Blowout
    28. Inefficient Hash Cluster

    29. High Volume Index Scans
    30. High Volume Nested Loops
    31. Partition Prune
    32. Star Joins
    33. Self Joins
    34. Sorts
    35. Index Join

    36. Direct Load Insert
    37. Create Table as Select
    38. Updateable Join Views
    39. Truncate and Replace
    40. Drop and Rebuild Indexes
    41. Rowid Range

    42. Concurrent Cursors
Downloads [ Return to OraFAQ.com ]