It is recommended that you load data in chronological order to obtain an optimized database.
When loading large amounts, you can obtain significant loading performance improvements by firstly sorting data on the date field, followed by the fields corresponding to entities with the smallest Max Item Numbers. For example, let’s consider a table with the following fields: Date, Customer, Product, Sales Amount and with Month, Product and Customer as the corresponding entities. Supposing the number of customers is greater than the number of products then the source data should be sorted by date-product-customer fields If you are loading data through ODBC, use the ORDER BY clause in the SQL statement to sort the data or create an index on the table.