Uploaded image for project: 'MariaDB Server'
  1. MDEV-6713

A join query is faster with index_condition_pushdown=off

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.5.39, 10.0.14
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      An example from customer: a join query is faster when one runs it with index_condition_pushdown=off. The difference is not big, but it's repeatable, so it is worth to investigate it.

      Query and dataset were provided by joffrey.

      Details are here in private comments (it's customer data).

        Attachments

          Activity

            People

            • Assignee:
              psergey Sergei Petrunia
              Reporter:
              psergey Sergei Petrunia
            • Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated: