You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@calcite.apache.org by GitBox <gi...@apache.org> on 2020/01/20 07:47:56 UTC

[GitHub] [calcite] vlsi commented on issue #1763: [CALCITE-3738] Missing order by logical plan for insert statement

vlsi commented on issue #1763: [CALCITE-3738] Missing order by logical plan for insert statement
URL: https://github.com/apache/calcite/pull/1763#issuecomment-576148007
 
 
   Even though it does not guarantee that the order will be preserved, it makes sense to keep the sorting.
   
   For instance, it would enable to cluder rows appropriately, so later selects would be faster (less physical IO).
   
   Oracle DB explicitly mentions that case in the documentation: https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_7002.htm#SQLRF54628

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services