• Query Optimization
    • Fully Compatible
    • 200
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Sometimes, part of the predicate can be pushed down to the IXSCAN stage filter and minimise or even avoid fetching. 

      Predicate: AND [a=1, b=1]

      Sort: c_1

      Index: (c_1_a_1)

      Resulting query

      FETCH
          filter: AND [a=1, b=1]
          IXSCAN:
              pattern: (c_1_a_1)
      

       

      Optimal query:

      FETCH
          filter: b=1
          IXSCAN:
              filter: a=1
              pattern: (c_1_a_1)
      

              Assignee:
              Carlos Alonso Pérez
              Reporter:
              Carlos Alonso Pérez
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Created:
                Updated: