Timeline for Oracle - WHY do an ORDER BY for INSERTs AS SELECT?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 10, 2018 at 20:10 | vote | accept | Marc | ||
| Oct 1, 2014 at 23:49 | history | edited | Marc | CC BY-SA 3.0 |
Added some information on the setup of the database: static, no other processes accessing tables during the ETL, etc.
|
| Oct 1, 2014 at 9:28 | answer | added | Phil Sumner | timeline score: 3 | |
| Oct 1, 2014 at 2:24 | comment | added | cha |
It will make sense if the table you are inserting into tables that have clustered indices. By including the order by the inserted data will be sorted that could potentially speed up the insert process. But most likely they just used some existing queries and converted them to insert queries
|
|
| Oct 1, 2014 at 0:51 | history | asked | Marc | CC BY-SA 3.0 |