Derby
  1. Derby
  2. DERBY-884

allow and use backward scans on indexes.

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.1.3.1
    • Fix Version/s: None
    • Component/s: SQL, Store
    • Urgency:
      Low

      Description

      Improve the access interface to support backward scans, currently only forward scans are supported.

      Improve the btree implementation to support backward scans. The structure could support this, the work just has not been done. With
      row level locking, concurrent tree splitting, and current assumptions
      throughout the access method that scans go top/down, left to right the
      work to do a backward scan is harder than doing a forward scan. Also
      once the store portion is done, there would be necessary changes to:
      optimizer, execution engine, and scan interface to allow the backward
      scan. This would be a hard first project.

      Improve the optimizer to understand derby indexes now support backward scans.

      Improve the execution engine to use the new backward scan interfaces to execute backward scans.

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Unassigned
              Reporter:
              Mike Matrigali
            • Votes:
              5 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:

                Development