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 "Laura Stewart (JIRA)" <ji...@apache.org> on 2007/04/20 23:57:15 UTC

[jira] Updated: (DERBY-2499) Update Tuning Guide documentation to reflect the new static IN list transformation that occurs as a result of DERBY-47.

     [ 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_1.diff

Attaching a patch and an html for the updates to the IN predication transformations.

> 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, 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.