You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Mamta A. Satoor (JIRA)" <ji...@apache.org> on 2012/09/30 02:08:07 UTC

[jira] [Updated] (DERBY-4612) Improve the cost model for user-defined functions

     [ 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