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

          Gavin made changes -
          Workflow jira [ 12322156 ] Default workflow, editable Closed status [ 12801870 ]
          Mamta A. Satoor made changes -
          Labels derby_triage10_11
          Urgency Low [ 10053 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-5149 [ DERBY-5149 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-4831 [ DERBY-4831 ]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-1748 [ DERBY-1748 ]
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-481 [ DERBY-481 ]
          simmi iyer created issue -

            People

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

              Dates

              • Created:
                Updated:

                Development