Comment 1 for bug 913030

Sergey Petrunia (sergefp) wrote :

The first attempt was this patch:

http://lists.askmonty.org/pipermail/commits/2012-January/002893.html

  BUG#913030: Optimizer chooses a suboptimal excution plan for Q18 from DBT-3
  - Added SJ_MATERIALIZATION_LOOKUP_MATCH_RATIO=0.75, made the optimizer assume
    that this is the probability that a lookup in semi-join materialized table will
    produce a match.

.. decided not to push it.