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

Add support for creating index on expressions

    Details

    • Type: Improvement
    • Status: Open
    • Priority: 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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated: