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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2010/04/12 18:49:49 UTC

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

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


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 contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira