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:
us...@infra.apache.org


With regards,
Apache Git Services

Reply via email to