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

Enhance Derby optimizer and execution model to support effective use of multiple indexes on one table. Derby currently can use one index on a table and there are many situations where using multiple indexes on a table could improve performance significant

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.2.1.6
    • Fix Version/s: None
    • Component/s: SQL
    • Urgency:
      Low
    • Bug behavior facts:
      Performance

      Description

      Enhance Derby optimizer and execution model to support effective use of multiple indexes on one table. Derby currently can use one index on a table and there are many situations where using multiple indexes on a table could improve performance significantly. Please see the discussion at http://article.gmane.org/gmane.comp.apache.db.derby.devel/16099

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                mkutty Manjula Kutty
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated: