[
https://issues.apache.org/jira/browse/DERBY-6310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13743769#comment-13743769
]
Rick Hillegas commented on DERBY-6310:
--------------------------------------
Hi Sebastian,
That is a big data set. Note that ForeighTableVTI implements RestrictedVTI.
That means that projections (limiting which columns are selected) and
restrictions (limiting which rows are selected) are pushed into the table
function. That can vastly reduce the size of the data rectangle returned by
ForeignTableVTI and therefore the amount of data which has to be thrown into
the sorter.
Thanks,
-Rick
> NLS SESSION SORT
> ----------------
>
> Key: DERBY-6310
> URL: https://issues.apache.org/jira/browse/DERBY-6310
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.8.2.2
> Environment: Java 1.6 / 1.7, Derby 10.8.2.2
> Reporter: Sebastian Ritter
>
> Migrating from Oracle missing SQL Statement:
> ALTER SESSION SET NLS_SORT=binary
--
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
