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

Add support for creating index on expressions

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:

              Slack

                Issue deployment