[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

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.2.1.6
• Component/s: SQL
• Labels: derby_triage10_11
• Urgency: Low
• Bug behavior facts: Performance
• Assignee: Unassigned
• Reporter: Manjula Kutty
• Created: 27/Apr/06 02:20
• Updated: 25/Jun/13 14:57

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

Issue Links

• relates to: DERBY-6226 enhance optmizer to use multiple probes into multiple indexes to satisfy OR queries on different columns.
• relates to: DERBY-481 implement SQL generated columns