Query Optimization in Oracle

  • Enable Javascript for extra tools
  • React
  • Bookmark
  • Print
  • React
  • Executive Summary

    This paper describes Oracle's query optimizer, a key database component that enables Oracle's customers to achieve superior performance.

    Unmatched Technology

    Oracle's query optimizer technology is unmatched in the breadth of its functionality, and this paper provides a detailed discussion of all major areas of query optimization.

    Some Image

    Information block C, a long block spanning both columns

    Some ImageThe image resides on the left. There is a 6pt margin to its right. The image sizes up to 288pt by 162pt. It does so, because the table cell in which it lives sports a class named "double".

    More

    Information block A, with a rather large title

    1. What is a query optimizer? What does Oracle provide for query optimization? Transitive predicate generation
    2. What does Oracle provide for query optimization? What is a query optimizer?
    3. Transitive predicate generation. Transitive predicate generation. What is a query optimizer?

    More

    Information block B

    1. SQL Transformations
    2. Heuristic query transformations
    3. Common subexpression elimination
    4. Simple view merging
    5. Complex view merging
    6. Subquery flattening

    More

    Information block C, a long block spanning both columns

    Some ImageThe image resides on the right. There is a 6pt margin to its left. The image sizes up to approx. 288pt by 162pt. It does so, because the table cell in which it lives sports a class named "double".

    More

    Information block D

    Some ImageThis information block holds a description, an image, and a link to more items. The image is smaller because the table cell in which it lives does not sport the class named "double". Instead, the table cell sports no class at all.

    More

    Information block E

    This information block holds a description, a drop-down, and a link to more items.

    More

    Information block F, another long block spanning both columns

    This is an information block that also spans 2 columns, but this time there is no image. Why anyone would want to create a block like this remains a question for us.

    More