Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2226

Move column bitset computation to IndexToBaseRowNode

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.3.1.4
    • Component/s: SQL
    • Labels:
      None
    • Bug behavior facts:
      Performance

      Description

      The constructor for IndexRowToBaseRowResultSet
      takes a bitset describing the columns coming from the heap and a
      bitset describing the columns coming from the index. But in every
      IndexRowToBaseRowResultSet one also has to compute all referenced
      columns (union of heap and index bitsets), and frequently also those
      columns only coming from the heap (set difference between heap and
      index).

      But the value of these "set products" seem only to depend on objects
      that are fixed at compile time (in IndexToBaseRowNode), so it would be
      cleaner (and possibly more efficient) to compute these products there.

        Attachments

        1. derby-2226.v1.diff
          9 kB
          Dyre Tjeldvoll
        2. derby-2226.v1.stat
          0.5 kB
          Dyre Tjeldvoll
        3. derby-2226.v2.diff
          10 kB
          Dyre Tjeldvoll
        4. derby-2226.v2.stat
          0.6 kB
          Dyre Tjeldvoll

          Activity

            People

            • Assignee:
              dyret Dyre Tjeldvoll
              Reporter:
              dyret Dyre Tjeldvoll
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: