Is it worthwhile sorting loading processes (INSERTS)?
The decisive factor is the size of the table and the size of the data cache. If all data pages of the table to be loaded are in the data cache, then there is no point in sorting the data to load. From a performance point of view, the sorting may thereby be unnecessary, but each unsorted insert runs the risk of deadlocks. When you make an unsorted insert you must therefore ensure, by using the application logic, that there cannot be any deadlocks. In this way, small tables can be loaded without being sorted. However, if you have large tables and not all data pages could be loaded into the data cache, then you need to sort the data to load it. Loading unsorted data into large tables generates a high I/O-load and cannot be carried out efficiently.
