Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Sun, 30 Sep 2012 11:08:07 +1100 (NCT)
From: "Mamta A. Satoor (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <1415539102.144192.1348963687596.JavaMail.jiratomcat@arcas>
Subject: [jira] [Updated] (DERBY-4612) Improve the cost model for
 user-defined functions
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DERBY-4612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mamta A. Satoor updated DERBY-4612:
-----------------------------------

    Urgency: Normal
     Labels: derby_triage10_10  (was: )
    
> Improve the cost model for user-defined functions
> -------------------------------------------------
>
>                 Key: DERBY-4612
>                 URL: https://issues.apache.org/jira/browse/DERBY-4612
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>            Reporter: Rick Hillegas
>              Labels: derby_triage10_10
>
> Right now the optimizer assumes that user-defined functions are expensive to run. For this reason, the optimizer avoids pushing function invocations far down in the query plan. It would be good to give function designers the ability to override the default cost model so that the optimizer can create more efficient plans for queries which invoke user-defined functions.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira