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

Add support for creating index on expressions

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.0.2.1
    • None
    • SQL
    • Solaris
    • 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

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4831 Support for auto-calculated (virtual) columns

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-5149 <column> LIKE UPPER( <string constant> ) result in a table scan even if a valid index exists on <column>

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-1748 Global case insensitive setting

          • Major - Major loss of function.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-481 implement SQL generated columns

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              simmi_iyer simmi iyer
              Votes:
              4 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated: