Nsort can also help make more efficient use of your hardware. With Nsort, you can get your data loaded more quickly without having to purchase more processors or memory. Load the data. This database sort usually takes longer than the actual data load. In some cases presorting can also speed up the incremental loads of daily or weekly additions to tables that already exist.
Some data warehouses allow part of a table to be offline or disabled during the load.
If the newly loaded data is not already sorted, the data warehouse must sort the new data in order to create the new portion of the table index. Nsort's superior sort speed saves time by eliminating the data warehouse's sort of the incremental data. Incoming load data can contain bad records or data that is not germane to your application. Nsort can help by selecting just those records you want to load into your database. Nsort can perform range checking and make sure that required fields are present.