db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laura Stewart (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2499) Update Tuning Guide documentation to reflect the new static IN list transformation that occurs as a result of DERBY-47.
Date Mon, 23 Apr 2007 20:27:15 GMT

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

Laura Stewart updated DERBY-2499:
---------------------------------

    Attachment: rtuntransform582.html
                derby2499_2.diff

Army - I believe that I have addressed all of your corrections with the exception of 1.  Typically
all examples start flush left. Then we indent for different parts of the command and SQL statement.
 For the smaller examples, I did indent. but for the JDBC and SQL examples I kept them as
is.

Please let me know if you see anything else that needs to be corrected !

> Update Tuning Guide documentation to reflect the new static IN list transformation that
occurs as a result of DERBY-47.
> -----------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2499
>                 URL: https://issues.apache.org/jira/browse/DERBY-2499
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Documentation
>    Affects Versions: 10.3.0.0
>            Reporter: A B
>         Assigned To: Laura Stewart
>            Priority: Minor
>         Attachments: derby2499_1.diff, derby2499_2.diff, rtuntransform582.html, rtuntransform582.html
>
>
> DERBY-47 changed the static rewrite logic for IN lists.  Whereas we used to create a
BETWEEN predicate for IN-lists that contain all constants and then use that predicate to limit
the scan, we now create a "probe predicate" for IN-lists that contain all constants *and/or*
parameter nodes and then use that new predicate to perform execution-time probing.
> The documentation in the Tuning Guide needs to be updated to reflect this change in behavior.

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


Mime
View raw message