Terrifying Execution Plan with cost of 18E (exa)

The newest piece of my bloomer collection is a query with an execution plan that has 18E of cost. I am no believer in absolute cost numbers, but this one is just nice.

This exa-executionplan is the new definition of Exadata….

Keep your fingers off ;)

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “Terrifying Execution Plan with cost of 18E (exa)”

  1. usn Says:

    The view used was flooded with USE_NL hints. We removed them, and this masterpiece works.

    Learn: Trust your CBO…


  2. alex Says:

    what’s time of exec?

  3. usn Says:

    It failed due to overflooding of the temp tablespace. :)
    But I guess: “ages”


Leave a Reply