Derby
  1. Derby
  2. DERBY-455

Add support for creating index on expressions

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 10.0.2.1
    • Fix Version/s: None
    • Component/s: SQL
    • Environment:
      Solaris
    • Urgency:
      Low

      Description

      As per Derby doc, indexes can be created only on simple column names.

      Creation of index on expressions will boost performance of queries with those expressions in where clause.

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Unassigned
              Reporter:
              simmi iyer
            • Votes:
              5 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:

                Development