db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ronald Tschalaer (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4136) Allow optimizer overrides for UPDATE and DELETE
Date Tue, 31 Mar 2009 23:35:50 GMT
Allow optimizer overrides for UPDATE and DELETE

                 Key: DERBY-4136
                 URL: https://issues.apache.org/jira/browse/DERBY-4136
             Project: Derby
          Issue Type: Improvement
          Components: Performance
    Affects Versions:
            Reporter: Ronald Tschalaer
            Priority: Minor

Since UPDATE and DELETE statements effectively run a query behind the scenes to find the rows
to update or delete, it would be useful to be able specify optimizer overrides (-- DERBY-PROPERTIES)
for these statements too. As a specific use case, I have an issue with locking where I need
to ensure the indexes are always used in order to prevent deadlocks. The current workaround
is to run a SELECT (where I can supply the appropriate --DERBY-PROPERTIES index=...) with
an updatable ResultSet and do the updates/deletes on the ResultSet. While this works, it is
uglier and less clear than the corresponding UPDATE/DELETE statements.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message